| Subject | SQL with returning value doesn't fire OnError event on lock conflict |
|---|---|
| Author | Thierry Holtzmann |
| Post date | 2013-10-18T16:56:04Z |
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
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