Subject Re: Strange error in FB CS 2.1.3
Author jegazarco
I have found the problem. There was a table used in a lot of triggers that has an assignment of type new.FIELD = XXX, and that was causing the error in FB 2.1.3

--- In firebird-support@yahoogroups.com, Fernando Medeiros <fdomds@...> wrote:
>
> tried to update ibx ?
>
> 2009/12/21 Fernando Medeiros <fdomds@...>
>
> > what happens to manipulate the database with a program like ibexpert ?
> > perhaps the problem is not just the database, try dbx connections.
> > []s
> >
> >
> >
> > 2009/12/19 Dimitry Sibiryakov <sd@...>
> >
> > > This is very complicated. I have 3000 triggers in my app, and a lot of
> >> triggers updates tables that has trigers that update tables.....
> >> >
> >> > From my app, simply opening a table, using IBX, raises an exception, i
> >> think that's when preparing the update of that table.
> >> >
> >> > May be useful with this new restriction, showing in the message what
> >> table/trigger is involved.
> >> >
> >> > I continue searching..
> >>
> >> You can simply try to create new database from script (you do have
> >> original script, don't you). You'll be pointed to exact error place.
> >> If you don't have the script, you can extract metadata from database
> >> using isql.
> >>
> >> SY, SD.
> >>
> >>
> >> ------------------------------------
> >>
> >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >>
> >> Visit http://www.firebirdsql.org and click the Resources item
> >> on the main (top) menu. Try Knowledgebase and FAQ links !
> >>
> >> Also search the knowledgebases at http://www.ibphoenix.com
> >>
> >> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >> Yahoo! Groups Links
> >>
> >>
> >>
> >>
> >
> >
> > --
> > http://twitter.com/fernandomds
> > http://fernandomedeiros.com.br/blog
> >
>
>
>
> --
> http://twitter.com/fernandomds
> http://fernandomedeiros.com.br/blog
>
>
> [Non-text portions of this message have been removed]
>