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