RE: [DUG] Delphi SQL issue

2007-02-25 Thread karlreynolds
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

RE: [DUG] Delphi SQL issue

2007-02-25 Thread Hayward, Phillip
38824 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Edward Koryagin Sent: Friday, 23 February 2007 10:33 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Delphi SQL issue Try this one: ParamByName('DT').AsTime

RE: [DUG] Delphi SQL issue

2007-02-25 Thread Hayward, Phillip
' 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

Re: [DUG] Delphi SQL issue

2007-02-23 Thread Edward Koryagin
Try this one: ParamByName('DT').AsTime := EffluentRec.DT; Regards, Edward. --- Hayward, Phillip [EMAIL PROTECTED] wrote: I am using the following piece of code on a Test server and am trying to install it on the Production server. with dm.qryUpdate do begin SQL.Clear;