I assume you mean tables not files, everything is inside on fdb file.

The only way I can think of to get Selectable Stored Procedure names
would be a query something like:

select RDB$PROCEDURE_NAME
from RDB$PROCEDURES
where RDB$PROCEDURE_SOURCE CONTAINING 'SUSPEND;'

Its not bullet proof, and wont work if you delete the source or put
the word suspend; in one of the comments or something, and I don't
know whether it is stored the same way in FB2.0, but for FB1.5.x it
should work fine.

Adam







--- In firebird-support@yahoogroups.com, "Michael L. Horne"
<guardian@p...> wrote:

> I had hoped that I could write my own sql to supply
> results to the program but it doesn't allow that.
> It tries to do all the work its self. First it shows
> a list of the files and views for you to pick from
> then a list of the fields in the file you chose.
>
> So there is no way currently to have it pick a
> stored procedure. I was hoping that someone would
> have a trick?
>
> Thanks
>
>
> > -----Original Message-----
> > From: Alan McDonald [mailto:alan@m...]
> > Sent: Wednesday, April 06, 2005 5:40 PM
> > To: firebird-support@yahoogroups.com
> > Subject: RE: [firebird-support] Connecting with ODBC - Need a
> > trigger on SELECT???
> >
> >
> > do you use SELECT from SP? or EXECUTE?
> > If it's a selectable SP. use SELECT
> > Alan
> >
> >
> >
> > >
> > > Hello,
> > >
> > > I am connecting to Firebird from a program with ODBC.
> > >
> > > In the program it allows me to select from tables and views
> > > but not Stored Procedures and match the fields in those
> > > tables up to the programs fields.
> > >
> > > The program seems to be limited in that it expects
> > > a flat file of shipping info with all the addresses, ...
> > > for a package in a single record. We don't store it that
> > > way.
> > >
> > > The program I am trying to setup is UPS WorldShip and
> > > I can get it to connect and pull data, just as things
> > > are I will be forced to create another file and update
> > > it every time the order records are changed.
> > >
> > > So, I was wondering if there is a way where I could fire
> > > a trigger on a select? Or trick ODBC into reporting a
> > > stored procedure as a file? Or does anyone have another
> > > suggestion?
> > >
> > > Thanks
> > > Michael L. Horne