> text to lcSql noshow > update acc_mf > set ob_dr = ob_dr + ?lnObDr, > ob_cr = ob_cr + ?lnObCr > where ac_level < '5' > and ac_no = ?lcAcNo > endtext > IF SQLExec(hConn, lcSql) < 0 > AERROR(laError) > MessageBox([Can not update table ] +laError[1,2]) > ENDIF ......SQLExec() is running without any problem. SQLExec() Returns 1 when I run it. I think COMMIT has to do with this, But on backend setting is Autocommit, which is Default behaviour of SQL Server.