Thank you for your information.
>>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
>
>It does look like we are doing the same thing. I dismember where I saw the info on using a semi-colon, but if you look up "batches, executing statements with ODBC" in the BOL you will see one example.