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