results from execSQL

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
deadflowers
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 28.01.2010, 21:36

results from execSQL

Post by deadflowers »

What does the meaning of execSQL ? if i want to know the results of execSQL whether successful or failed?
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

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
Image
Post Reply