results from execSQL
Posted: 29.01.2010, 00:13
What does the meaning of execSQL ? if i want to know the results of execSQL whether successful or failed?
Execsql is used insead of Open for non-select statements. If you're executing updates, inserts or deletes, reading the value of ZQuery.RowsAffected shows the number of records affected by the statement (when available for the statement, depending on the database server).
And of course, when the query fails (eg. bad syntax), an exception should be raised by zeoslib automatically.
Mark