🚀 go-pugleaf

Microsoft DBMS use this syntax

UPDATE TableName SET FieldName1=#12/31/2003 12:00:00.000#,
FieldName2='Hello'

You may use parameters without ADO - most data providers (except some very
special) support command parameters.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Steve Aletto" <steve_alettoNOSPAM@THANKShotmail.com> �������/�������� �
�������� ���������: news:4029e222@newsgroups.borland.com...
> Hi Viatcheslav,
>
> thank you for the answer, I didn't know about parameters.
>
> Anyway, I forgot to mention, I'm looking for an SQL statement to solve the
> problem so that I can use it even when I don't use ADO.
>
> So far, the only solution I found is substituting the comma if present in
> the date/time field.
>
> WRONG: UPDATE TableName SET FieldName1=1234,567, FieldName2='Hello'
>                                           ^^^
> CORRECT: UPDATE TableName SET FieldName1=1234.567, FieldName2='Hello'
>
> Do you have any suggestion about this? Maybe treating that field as string
> instead of double? I don't know, I think there could be problems that way
as
> well.
>
> And how to handle different databases? I mean, with SQL server I must
> substract 2.0 to the date/time field compared to Access. So I should use
> different statements depending on the DB, is it correct?
>
> Thanks.
>
> Steve.
>
>