Subject RE: [firebird-support] FB 1.5.3 return data type not supported
Author Bill Meaney
> Bill Meaney wrote:
>
> >
> >>I have a DB running on FB1.5.1 SS dialect 1 that works fine. I
> >>moved it to a brand new server with FB1.5.3 Classic
> >> dialect 1. (This is the first time I've used Classic.)
> >>
> >>UPDATE sUsr
> >> SET FllNam = 'My Name'
> >> WHERE UsrId = 23
> >>
> >>I get the following message:
> >>
> >>Unsuccessful execution caused by system error that does not preclude
> >>successful execution of subsequent statements.
> >>return data type not supported.
> >>
>
> There's something you're not telling us. That error message comes
> from the function handling code - somewhere you're calling a user
> defined function. V1.5.3 is a bit tighter about handling return
> values to avoid catastrophic results in some cases.
>
> Regards,
>
>
> Ann
>

There is an update trigger on the table that calls a UDF. I will try it
again without the UDF and see what happens.

The problem seems to happen with Classic vs SS rather than v1.5.1 vs 1.5.3.

Thanks, Ann

Bill Meaney