results from execSQL
Moderators: gto, EgonHugeist
-
- Fresh Boarder
- Posts: 3
- Joined: 28.01.2010, 21:36
results from execSQL
What does the meaning of execSQL ? if i want to know the results of execSQL whether successful or failed?
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
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
And of course, when the query fails (eg. bad syntax), an exception should be raised by zeoslib automatically.
Mark