[DUG] Delphi SQL issue

[Hayward, Phillip]

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.