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
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
'
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
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;