Hi

I'm trying to execute an SQL-INSERT on a ORACLS table, by I keep getting the error message: Missing comma.

ORACLE structure:
Currency VARCHAR (3)
Exch_rate NUMBER (12,6)
Startdate DATE


*-- Foxpro code
STORE SQLCONNECT('Oracle', 'xxx', 'yyy') TO nHandle
cSql = [INSERT INTO Oracletable VALUES ('ABC',14.1234,01-06-2003 00:00:00)]
?SQLEXEC(nHandle,&cSql)

This always return -1 and erroe 1526, Missing comma.

When I insert data to Oracle tables that only have fields of VARCHAR everything works fine.

What am I dooing wrong ????????????