Hi,

No. 1 of my questions works now very great. Many thanks.

But I have still problems with problem no. 2 and 3.

no. 2 again :
How can I extract the metadata of a stored procedure / trigger like :

ALTER PROCEDURE PROCEDURENAME (VALUE1 INTEGER,
VALUE2 VARCHAR(10))
returns (RESULT1 VARCHAR(5),
RESULT2 INTEGER,
RESULT3 INTEGER)
AS
declare variable ...;
declare variable ...;
declare variable ...;
begin
...
end

I tried to get it with schemacash, as you wrote me, but I cant find
the right method which could do this.
Is it the Procedure :
Procedure ExtractStoredProcedure(SQL: string; var StoredProcName:
string; const ParamNames: TStrings; ParamChar: char );

or the Procedure :
GetStoredProcedureSource(SP_Alter: boolean; SP_Name: string; SP_DSQL:
TIB_Statement; SP_Body: string ): string;

If it is one of both, which are the right parameters ?

and about no. 3 :
I am really sorry, I didn't find anything in the IB/FB Documentation.
Maybe I have the wrong one. Could you get me the exact name of it,
please?

Many thanks for all

Ronald

--- In IBObjects@yahoogroups.com, Nando Dessena <nandod@d...> wrote:
> Ronald,
>
> r> 1. How can I get all Names of the Stored Procedures and Triggers
in a
> r> Database?
>
> r> 2. How can I get the complete content of the Stored Procedure /
> r> Trigger if I have the name?
>
> r> 3. How can I detect any dependencies on a table?
>
> all your questions are answered by a combination of SchemaCache and
> the system tables. The former is documented in IBO's help file, the
> latter you'll find in IB/Fb documentation.
>
> HTH
> --
> Nando mailto:nandod@d...