We're using a remote connection to a VFP database. When doing an INSERT with an empty date field I get a data mis-match error.

? SQLPREPARE(myHandle, "insert into xyz (effect_dt) values (?m.datevar )")---> 1
m.datevar=DATE()
? SQLEXEC(myHandle) ----> 1
m.datevar={}
? SQLEXEC(myHandle) ----> -1
=AERROR(laError)
? laError[2] ----> "Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Data type mismatch"

A straight SQL Insert

INSERT INTO xyz (effect_dt) VALUES ( {} )

works just fine.

Any insight will be greatly appreciated.

TIA to all.........Rich