Subject RE: [IBO] Cannot view generators using IBSQL Generators tab
Author Jason Wharton
I'll look into this...

It would help if you told me the exact method you tested this.


> -----Original Message-----
> From: []On
> Behalf Of Helen Borrie
> Sent: Tuesday, June 17, 2008 10:39 PM
> To:
> Subject: Re: [IBO] Cannot view generators using IBSQL Generators tab
> At 06:01 PM 17/06/2008, you wrote:
> >Hi,
> >
> >I have some generators created in a firebird (v2.0.4) database.
> >However, I can't view them using the IBSQL (latest from IBO website)
> >desktop utility. I know the generators are in the database
> because I
> >can find the entries in RDB$GENERATORS and they are working
> fine. It
> >is just that browsing the database at the Generators tab show no
> >entries at all. Does anyone have any idea why?
> I don't have an idea *why* but I confirm that IB_SQL now
> seems unable to deliver the generators *from ODS 11.0 and
> 11.1 databases*. Still OK with ODS < 11. At a guess I'd
> wonder whether some confusion has arisen in the output
> fetched from this query, due to the addition of new columns
> to RDB$GENERATORS...? Maybe just needs a change from
> referring to Fields[n] to FieldByName.
> Helen