>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