I am seek a solution to a problem. I am not able to insert a date() or a dateime()
value from VFP using SQLEXEC() into an Access table with column values that are Date/time and Date. How is this achieved.
My Code
=SQLEXEC(nConnHandel,"insert into Performance(id,date,lastupdate) values(1,"+date()+","+Datetime+")")

I have also tried manually entereing the values
nresponce =SQLEXEC(nConnHandel,"insert into Performance(id,date,lastupdate) values(1,01/01/2004, 04/04.2004 01:01:01)")

i get a response value of -1 and i tried AERROR() and the vaue in it is .f.

Any Suggestions


Thank you,

Donald