--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 07:39 PM 16/02/2007, you wrote:
> >Hi
> >
> >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...

Thx Helen.

It looks like I sometimes do an illegal dynamic SQL ...

Michael

>
> ./heLen
>