Hi Benn

Is 01-06-2003 00:00:00 valid data, should it not be surrounded by something, like "01-06-2003 00:00:00" or {01-06-2003 00:00:00}?


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