>Hi Folks, and Happy New Year
>I am testing a MySql database on a Novell cluster, and it works great. I have a problem though, when entering a VFP date value into a MySql Date field. The record is entered, but i can't browse it, nor query it. I can't even query the table anymore, and i had to drop the table. In what format should i enter it?
>
>TIA
>Jaime
Jaime,
Either a canonical ODBC format or parametric entry should do (at least that was what I did in the past and worked) :
ODBC canonical :
ldDate = date()
SQLEXEC(lnHandle,;
"insert into myTable (mydate) values ('"+;
transform(ttoc(dtot(ldDate),1),'@R 9999/99/99 99:99:99')+"')" )
Parametric (I prefer) :
ldDate = date()
SQLEXEC(lnHandle, "INSERT INTO myTable (mydate) values (?m.ldDate)" )
Cetin