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 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] 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@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@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi