Hi John,

>I faced problem that, AERROR() doesn't return ODBC error if TABLEUPDATE(2, .F.) is failed. It works at design time but not EXE.

Instead of committing all records at once, you can create a loop using GETNEXTMODIFIED() and update record by record. Then you have full control over the process.