Hi,

the FLL @ www.vfp2c.com has a replacement function for SQLEXEC called SQLEXECEX which accepts a cursorschema description in one parameter ...

in the file "odbc.prg" in the example project (contained in the vfp2cexamples subfolder) there are codesamples on how to use it ...

e.g.

#INCLUDE vfp2c.h
SET LIBRARY TO vfp2c32.fll ADDITIVE
INITVFP2C32(VFP2C_INIT_ODBC)

&& assuming lnCon is a valid connection handle ...
lnRet = SQLEXECEX(lnCon,'SELECT someCol, someCol2, someDateTime FROM yourTable', 'cCursorName', '', 0, 'someDateTime D NULL')
IF lnRet = -1
 AERROREX('laError')
 DISPLAY MEMORY LIKE laError
ENDIF

If you're using an older VFP version the only other solution is defining a "view" in a DBC where you can also specify the datatype.
In VFP9 you can alter the datatype by specifying the cursorschema property in the CursorAdapter class.

Regards
Christian