I did recently do a fair amount of work on the OnError aspects because there
were some imperfections in them. Would you like a complimentary copy of the
latest version to try? It just may be that I have already addressed this
issue.

Please let me know.

PS. Sara sends her greetings!

Thanks,
Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Thierry Holtzmann
Sent: Friday, October 18, 2013 10:56 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] SQL with returning value doesn't fire OnError event on lock
conflict

I have a TIBOQuery with a sql statement like "select .. returning avalue".
On a lock conflict, the onError event doesn't get fired if I use the
Query.Open statement.
If I use Query.ExecSQL the OnError gets fired.
Is there any way to know in a single statement of such an error and get
the return value of the query if not ?
I first though of the properties IsEmpty = True and RowsAffected = 0,
but if the record is not located they return same values.
D2007 + IBO 4.9.14.52


------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgradeYahoo!
Groups Links