>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.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
