Hi Andrew

I tryed your different solutions, but none of them solved the problem.

With quates arround the datetime the errormessage change to: Not a valid Month

Using ltdate returns the original error message.

Best regards
Benn

>Hi Benn,
>
>In SQL-Server, you'd need to suttound the datetime with single quotes (and I'd use YYYY-MM-DD as well):
>

cSql = [INSERT INTO Oracletable VALUES ('ABC',14.1234,'2003-06-01 00:00:00')]

>SQL-Server would take the string and do an implicit conversion to a datetime type.
>
>I think Oracle is probably stumbling over the space in the INSERT statement.
>
>One alternative is to do this:
>

ltDate = datetime(2003,06,01,00,00,00)
>cSql = [INSERT INTO Oracletable VALUES ('ABC',14.1234,?ltDate)]

>
>Cheers,
>
>Andrew
>
>>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 ????????????