>cCommand = "update MyTable set Field1 = '111' where Field1 = '222'; update MyTable set Field2 = '111' where Field2= '222'" >SQLEXEC( nHandle, cCommand ) >>
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() ENDIFI think your code was OK also, but better to write them as separate lines and you should always check the return value of SQLExec.