Trapping for back-end errors

Classic Servoy
1

From the developer’s reference:

getExceptionMsg
Description Returns the text of an exception message when an error occurs with the query (if this option is available).
NOTE: The error is the actual error message that the backend database sends back. The text of the error may vary - depending on the backend database being used.

Question: what function is used to determine what b/e environment is in use, so as to code one’s error-trapping conditionally to accommodate various possible back ends?

thanks,

kazar

2

There is none. You can’t tell the “brand” of the database being used by any single condition. However, the text will contain the actual error text from the driver - so you don’t need to know the brand.

3

thanks Bob. I was anticipating getting a number only back – I guess there’s no answer better than “test and have a look”, huh…

kazar

4

:D

Unlike FileMaker ODBC errors - you get the whole text returned in (gasp!) human readable form.