Helen Borrie wrote:

>At 04:34 PM 7/04/2005 -0400, you wrote:
>
>
>What you've described so far isn't clear. Is it your program that supplies
>the list of tables and views, or somebody else's?
>
>The ODBC interface can query the system tables and find the definitions of
>tables and views. I guess you are using some utility program that does
>this. (There are no "files" in Firebird!!) With stored procedures,
>there's nothing in the metadata that could tell you (or the interface)
>which SPs were selectable and which were executable.
>
>
>
>

Vladimir had did this to allow ODBC to identify if a Procedure is
selectable or executable looking into BLR code for SUSPEND (IIRC twice
BLR_SUSPEND verbs indicates a selectable procedure, otherwise it's
executable).

>./heLen
>
>

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 06/04/2005