2d1
Subj : TADOQuery with datetime parameter
To   : borland.public.cpp.borlandcpp
From : Wolfgang Hardt
Date : Fri Aug 13 2004 03:14 pm

Hi all,

I'm using TADOQuery with one parameter of typ datetime for updating a
timestamp field in database..
When I call ExecSQL only the date part is stored in database. The time part
is loosing .
I've got the problem with Sybase and Oracle DB's.
Using BCB6 and OLEDB ODBC
____________
q->Active=FALSE;
q->SQL->Text="insert into test1 (datum) values (:a)";
TParameter *param=q->Parameters->FindParam("a");
if(param)
    {
     param->Value = TDateTime::CurrentDateTime();
     param->DataType=ftDateTime;
    q->ExecSQL();
    }
----------------
Any ideas?

.

0