If you need to get the field names and table names, you can query the
system tables RDB$RELATION_FIELDS and RDB$RELATIONS
(do a join)

Thanks !
- Goutam

> -----Original Message-----
> From: Leonardo Nakahara de Oliveira [mailto:okinawadin@...]
> Sent: Tuesday, December 28, 2004 12:54 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Stored Procedure Creator Problem
>
>
>
> Hello All,
>
> I'm using Firebird and I'm developing a Stored Procedore
> Creator so I can make my work faster.
>
> But the problem is that the
> FirebirdNETProvider-1.6.3-NET1.1 has a method which is now
> obsolet. The method is the FbDbSchemaType Enumeration which
> returns the data from the Tables, Columns, etc.
>
> Since I'm developing a Stored Procedure Creator, I need
> my code to run over a database and return it's tables and
> it's columns. And, returning it, I can create a loop which
> will construct my Stored Procedures.
>
> Does anyone knows how to do it using another component,
> since this is now obsolet?
>
> Thanks
>
> Leonardo Nakahara de Oliveira
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> $4.98 domain names from Yahoo!. Register anything.
> http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.