Hi Andrew

You are right, but it did'nt solve the problem............

>Hi Benn,
>
>I don't think you need the macro substitution character in the SQLEXEC() statement.
>Try:
>

?SQLEXEC(nHandle, cSql)

>Cheers,
>
>Andrew
>
>>Hi Tore
>>
>>The dateformat is valid. If it is entered in another way it returns an error.
>>
>>>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 ????????????