> In SQL Server use
> INSERT INTO TableS
> VALUES(GETDATE(),'1','2','3')
or INSERT INTO TableS
VALUES(GETDATE(),1,2,3)
When you're inserting general date values the safest way is to use
parameters as then you don't get stuffed up by local date formats :
qry.SQL.Add('INSERT INTO TableS VALUES(:Date, :Int1, :Int2, :Int3)');
qry.Prepare;
qry.Parameters.ParamByName('Date').AsDate := DateVar;
qry.Parameters.ParamByName('Int1').AsInteger := Integer1;
qry.Parameters.ParamByName('Int2').AsInteger := Integer2;
qry.Parameters.ParamByName('Int3').AsInteger := Integer3;
qry.Execute;
With Oracle you can pass the formatted date string to an Oracle function
with the format specified.
Stephen
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
