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 ????????????
Benn Kjaer
MS Certified Professional - Visual Foxpro
"There is something rotten in the state of Denmark"
"Why make user-friendly programs, when there aren’t any friendly users :o)"