null date values with parametred query

axelv · Post by **axelv** » Wed 22 Jun 2005 16:30

when I used 'MyQuery.Params[x].Clear' for inserting some empty dates in a column database i have an error message so i am forced to use the following syntax : MyQuery.Params[x].AsDate := 0. Is it normal ?

and also I can't use the syntax MyQuery.Params[x].AsDateTime to insert some date values in a table

Do I use the good syntax for doing these actions ?

Thank you for your time !

Ikar · Post by **Ikar** » Thu 23 Jun 2005 10:10

Please submit the create table script.

Do you use DbxSda or MyDAC?

axelv · Post by **axelv** » Tue 28 Jun 2005 15:51

that's ok i'll find the solution this was because i didn't initialize params[j].DataType