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 ????????????
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.