>Hi,
>
>How do you string two or more UPDATE commands to be executed with SQLEXEC()? I tried separating them with ";" but I get error message. Here is my test string:
>
>

>cCommand = "update MyTable set Field1 = '111' where Field1 = '222'; update MyTable set Field2 = '111' where Field2= '222'"
>SQLEXEC( nHandle, cCommand )
>

>
>What is wrong with the above syntax? TIA.

Try using this

TEXT to lcSQL NOSHOW
   UPDATE myTable SET Field1 = '111' WHERE Field1 = '222';
   UPDATE myTable SET Field2 = '111' WHERE Field2 = '222';
ENDTEXT

if SQLEXEC(nHandle, m.lcSQL) <0 
   &&Check the actual error with aerror()
ENDIF

I think your code was OK also, but better to write them as separate lines and you should always check the return value of SQLExec.