Subject Re: [firebird-support] Re: Cant Insert DateTime to TimeStamp Field (FireBird)
Author Martijn Tonies
> Thanks For the Quick Reply
> Error Message is :
> Arguments are of Wrong Type or out of Acceptable range or Are Conflict
> with One Another.
> ---------------------
> Here is the Code:-
> AdoQry.Parameters.ParamByName('Prm0').DataType:= ftTimeStamp;

"ftTimeStamp" is a dbExpress specific type. Check the docs on this.

> AdoQry.Parameters.ParamByName('Prm0').Value :=
> VarToDateTime(RSt.Fields['S_DATE'].Value);
> ---------------------
> RSt.Fields['S_DATE'] is a DateTime Field in MSAccess
> If I use 'ftDateTime' it will insert Null Values.

What's wrong with:

ParamByName('..').AsDateTime := ...

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!