Using IBDAC latest version.
When I attempt to open a storedproc which contains an execute statement - and does not return rows I receive 'SQL statement doesn't return rows' error message in a box - this is correct.
However I would like to catch the error and deal with it without interrupting the programme with the error box.
I've tried putting the open call in a try except block but the error box still shows.
Thanks
Trap/catch 'SQL statement doesn't return rows'
Re: Trap/catch 'SQL statement doesn't return rows'
Unfortunately, we can not reproduce the problem as you have described it. Please send a small sample to viktorv*devart*com to demonstrate the issue, including a script to create and fill in the test database object.
Re: Trap/catch 'SQL statement doesn't return rows'
Thank you.
Well this is embarrassing..
In the process of making a small test project to send to you I discovered that - Surprize, surprize - the error is in my code. Your code does allow me to catch the exception.
Apologies for wasting your time.
Well this is embarrassing..
In the process of making a small test project to send to you I discovered that - Surprize, surprize - the error is in my code. Your code does allow me to catch the exception.
Apologies for wasting your time.
Re: Trap/catch 'SQL statement doesn't return rows'
Glad to see that the issue was resolved. Feel free to contact us if you have any further questions about IBDAC.