> 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
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com