Daniel,
PMFJI, I do chain/batch commands with SQLExec() all the time, and I never use the semicolon to "chain" the commands.
This is the way I would have done it.
TEXT TO lcSQL TEXTMERGE NOSHOW
update table set x = y where <<condition>>
select @@rowcount as rowcount
ENDTEXT
= sqlexec(liConnection, lcSQL, curResults)
And my question is, are we doing to same thing? Or they're different?
Hope you understand my question.
TIA.
Wan
>>Dear Vlad Grynchyshyn,
>>
>>Thank you for your help and I tested. It returned no. of records processed using VFP Native SQL Command. When I use SQLExec to issue the SQL command via ODBC, it can't. Do you know have any way to return no. of records processed? Thanks a lot....
>>
>>Best Regards,
>>
>>Justy Chow
>
>
>You can use the @@ROWCOUNT system variable to get this provided you execute it immediately after the update. So, you'd do something like this in VFP:
>
>
>=sqlexec(liConnection,"update table set x = y where {condition};" + ;
> "select @@rowcount as rowcount",curResults)
>?curResults.rowcount
>
>
>The trick is "chaining" the commands together. The semicolon in the middle of the command string does that.