Hmm,
If
SQLEXEC() return -1, then SQL command is invalid.
Try this:
=SQLSETPROP(hdbc,"DisplayWarnings",.T.)
=SQLSETPROP(hdbc,"BatchMode",.T.)
If VFP will display warnings, then ODBC driver don't support BatchMode.
MartinJ
>Thanks for the reply Martin. SQLEXEC() returns -1, so the problem seems related to the connection. For the moment I am using views defined in the DBC. Is there a problem with mixing SQLPT with remote views defined in the DBC using the same connection?
>
>Thanks for your help.
>
>Alex
>
>>Hi Alex,
>> Maybe ODBC driver for Btrieve doesn't support BatchMode Processing...
>>How you call SQLEXEC() and SQLMORERESULT()?
>>
>>MartinJ
>>
>>>I am doing a series of SPT commands using a connection to an ODBC source (Btrieve) and am getting error messages indicating that SQLMORERESULTS is occuring.
>>>
>>>Do I have stay in a loop asking for SQLMORERESULTS ultil no more data is found before another SQLEXEC can be performed? I dont want results to arrive a few records at a time.
>>>
>>>TIA,
>>>
>>>Alex