Subject Re: [firebird-support] Which Error ?
Author Helen Borrie
At 07:39 PM 16/02/2007, you wrote:
>I have a program that sometimes has an runtime error.
>When it happens I get this back:
>IBErrorCode: 335544569 SQLCode: -104
>The IBErrorCode says this:
>dsql_error Dynamic SQL Error
>But this doesn't fit with the SQLCode.
>The SQLCode to the above errorcode is -902.
>-104 covers some other errors.

Yes: including DSQL errors

>Which should I look for ?
>The 335544569 alone ?
>Or some of the -104 errors ?

The top-level error only identifies the error as being a dsql
error. If it's a run-time error that hits sometimes and not others,
maybe looking at any statements being constructed at run-time could
yield clues. Also consider conditions that might pass invalid
arguments to parameters, etc. Are you running an SQL monitor in the program?

And if you are still using a Dialect 1 database, that's a possible
source of run-time errors...