Subject | RE: [firebird-support] FB 1.5.3 return data type not supported |
---|---|
Author | Bill Meaney |
Post date | 2006-02-02T22:41:47Z |
> Bill Meaney wrote:There is an update trigger on the table that calls a UDF. I will try it
>
> >
> >>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
>
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