Hi Ricardo:

Unfortunately I don't have an answer to your question but you raised one for me that I'm having a difficult time with. I am trying to get data back from a single table in VFP to Access via ODBC. All data (char, n, etc.) gets back fine but if I try to get a date back along with the other data everything blows up.

I've tried:

lddate="{d '2000-10-10'}", or
lddate="#10/10/2000#" or
lddate=dtoc(date())
lddate={^2000-01-01} etc., then

gnerror=sqlexec(sqlhandle, "insert into transactiontable (date)
values (?lddate)")

No matter how I try to format lddate it won't get back (gnerror = -1). If you have any ideas I'd be grateful.

Rob