Hi Dorin
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
>Try
>
>STORE SQLCONNECT('Oracle', 'xxx', 'yyy') TO nHandle
>lDateTime = {^2003-06-1 00:00:00}
>cSql = [INSERT INTO Oracletable VALUES ('ABC',14.1234,?lDateTime)]
>?SQLEXEC(nHandle,cSql)
>
>
>>>>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)"