Page 1 of 1

Trap/catch 'SQL statement doesn't return rows'

Posted: Fri 02 Jan 2015 15:36
by Dokkie
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

Re: Trap/catch 'SQL statement doesn't return rows'

Posted: Sun 04 Jan 2015 06:42
by ViktorV
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'

Posted: Sun 04 Jan 2015 23:27
by Dokkie
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.

Re: Trap/catch 'SQL statement doesn't return rows'

Posted: Mon 05 Jan 2015 05:47
by ViktorV
Glad to see that the issue was resolved. Feel free to contact us if you have any further questions about IBDAC.