[DUG] Delphi SQL issue

[Edward Koryagin]

Interbase datatype - timestamp.
--- "Hayward, Phillip" <Phillip.Hayward at chh.co.nz>
wrote:

> Thanks for that one Carl. Have tried this and it
> works. Am still
> interested in the root cause and hopefully will have
> time to return to
> it and investigate further, first priority at this
> time is to get it
> into production.
> 
> Thanks to everyone else for your responses.
> 
> Regards 
> Phil Hayward
> 
> System Analyst 
> Pinepanels Rangiora
> ph  (64) 3 313-2764
> fax (64) 3 313-2739
> Ext 38824
> Phillip.Hayward at chh.co.nz
> 
> 
> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz
> [mailto:delphi-bounces at ns3.123.co.nz]
> On Behalf Of karlreynolds at xtra.co.nz
> Sent: Monday, 26 February 2007 10:23 a.m.
> To: 'NZ Borland Developers Group - Delphi List'
> Subject: RE: [DUG] Delphi SQL issue
> 
> I've had similar problems with Date and DateTime
> parameters so now I use
> TimeStamp instead.
> 
> ParamByName('DT').AsSQLTimeStamp :=
> DateTimeToSQLTimeStamp(Trunc(EffluentRec.DT));
> 
> should work.
> 
> Cheers,
> Carl
> 
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> DISCLAIMER: This electronic message together with
> any attachments is 
> confidential. If you are not the intended recipient,
> do not copy, disclose or 
> use the contents in any way. Please also advise us
> by return e-mail that you 
> have received the message and then please destroy.
> Carter Holt Harvey is not 
> responsible for any changes made to this message and
> / or any attachments after 
> sending by Carter Holt Harvey. We use virus scanning
> software but exclude all 
> liability for viruses or anything similar in this
> email or any attachment.
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 


Send instant messages to your online friends http://au.messenger.yahoo.com