Page 1 of 1

null date values with parametred query

Posted: Wed 22 Jun 2005 16:30
by axelv
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 !

Posted: Thu 23 Jun 2005 10:10
by Ikar
Please submit the create table script.

Do you use DbxSda or MyDAC?

Posted: Tue 28 Jun 2005 15:51
by axelv
that's ok i'll find the solution this was because i didn't initialize params[j].DataType