🚀 go-pugleaf

Use parameter

UPDATE TableName SET FieldName=?

Q.Parameters[0].Value = Now();

//------------------------------------------
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:402905f6$1@newsgroups.borland.com...
> Hi all,
>
> I'd like to know what's the best way to set a date/time field in a
database.
> I thought the following was quite good (Q is a TADOQuery *):
>
> Q->SQL->Add("UPDATE TableName SET FieldName=" + String(double(Now())));
>
> But that's not true: with SQL server you should substract 2, furthermore
> comma must be substituted with dot (it depends on the international
settings
> of the PC though) and maybe some other bugs are behind the corner. I found
> many problems/differences handling the date/time field as a string, too.
>
> So, I'm looking for a sure and standard (same for many databases) way to
> achieve this simple job. Thanks for any hint.
>
> Steve.
>
>