Hi Cetin

Thanks, I have solved the problem. The main problem is that I work with a dateformat as DMY and not YMD, when I changed this it worked.

Regards
Benn

>Benn,
>Doesn't this owrk with Oracle (I don't have):
>
>m.myDate = {^2003/6/1}
>cSql = [INSERT INTO Oracletable VALUES ('ABC',14.1234,?myDate)]
>?SQLEXEC(nHandle,cSql)
>
>Or :
>cSql = [INSERT INTO Oracletable VALUES ('ABC',14.1234,'2003/06/01')]
>
>Cetin
>
>>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 ????????????