Subject Re: [IBO] IB_SQL Browser not displaying list of generators
Author Hans
Helen, I corrected that already quite a while back and if you
probably recompile the IB_SQL Browser project it will be
there. I know, just double checked, mine works.

However there are many other new Firebird 2.+++ features
not supported and extracting meta data now really doesn't
match the database structures anymore.

It has been difficult to contact Jason, it appears my email
to him always gets lost. Sometimes, months after, I get a message
back 'I found this message from you in my whatever email'

I've have been modifying my version of IB_SQL , but have no
idea anymore what the total status is and I have given up for
that reason.

Hans


----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <ibobjects@yound thikkahoogroups.com>
Sent: Friday, July 25, 2008 9:14 AM
Subject: [IBO] IB_SQL Browser not displaying list of generators


> Jason,
>
> The needed fix is to change the SQL for frmBrowse.qrGenInf in
> IBF_Browse.pas from
>
> SELECT RDB$GENERATOR_NAME
> FROM RDB$GENERATORS
> WHERE RDB$SYSTEM_FLAG IS NULL
> ORDER BY RDB$GENERATOR_NAME
>
> to
>
> SELECT RDB$GENERATOR_NAME
> FROM RDB$GENERATORS
> WHERE RDB$SYSTEM_FLAG IS NULL
> or rdb$system_flag = 0
> ORDER BY RDB$GENERATOR_NAME
>
> This affects all FB versions 2.0 and higher.
>
> Helen
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>