>>* Your code: >>IF EMPTY(tcSql) && Processing via an SQLPREPARE() statement >> tcSql = " " && So Error Routine has character value >> lnResult = SQLEXEC(tnConnection) && ????? >>>>
>lcSql = "UPDATE myTable SET myField = ?myValue WHERE pk = ?mypk" >IF oDataClass.prepare(tnConnection,lcSql) > SCAN > mypk = table.pk > myvalue = table.value > IF NOT oDataClass.sql_execute(tnConnection,lcSql) > ** Error Handling Code > ENDIF > ENDSCAN >ELSE > ** Error Handling Code >ENDIF > >***oDataClass.prepare >LPARAMETERS tnConnection,tcSql >=SQLPREPARE(tnConnection,tcSql) >** With appropriate error handling >Yuri question is what happens when you don't pass lcSQL? Are you passing the handle in this case?