Hi All,

I get the following error when I try to run the code below:
Connectivity error: [Microsoft][ODBC Microsoft Access Driver] Undefined function 'DTOC' in expression.

Code

lnResult = SQLEXEC( lnAccess,"INSERT INTO transaction "+;
"([promono],[batch],[filename],[problem],[dateout])"+;
" VALUES "+;
"(?tmpdata.promono,?tmpdata.batch,?tmpdata.filename,?tmpdata.problem,DTOC(?tmpdata.dateout))" )

If I leave out the DTOC I get a data type mismatch. The field in access
is a date/time field and the VFP field is a datetime field.

Anyone any ideas?

Thanking you in advance.