? 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.