Database backend best practice

What is the recommended way of integrating the database backend with FlexSim?
I tried using the db*() functions, but they only seem to work when the query is successful. Any exception results in a system dialog, which is not what I want most of the time. I have not found any way of intercepting database exceptions.
Does it mean that the backend has to be designed never to throw any exceptions? If I want to have my own exception handling (on the level of dealing with "duplicate key"/"key does not exist" type exceptions) I have to use the C++ API?
Thank you!
Vadim

Vadim,

There is no way in Flexsim of intercepting database exceptions. Flexsim's db* commands are designed with the assumption that queries will be well-formed and meaningful. That set of commands is also designed to rely on the error messages of the client database because that way the Flexsim developers (namely, me) didn't have to worry about all the ways that something could go wrong. A meaningful error from the database is more helpful to the user than simply some sort of generic Flexsim error message.

If you want more control over your database interactions, then a custom-written Flexsim-compatible DLL is probably the best option.

A.J.