don't bother - save yourself a lot of time and use IBComparer tool
http://www.ibexpert.com/download/PlugIns/ibdbcomp.zip

Alan

-----Original Message-----
From: Andrew Guts [mailto:andr@...]
Sent: Monday, 17 February 2003 10:16 PM
To: IB support
Subject: [ib-support] Extracting SP parameters from system tables.


Hello,

Gurus, help me please. I need to reconstruct compilable SP text from
database.
I'm trying to write a tool for applying SP changes from developer's to
production database.
How to retrieve SP parameter types (datatype names) from system tables?
RDB$PROCEDRES.RDB$PROCEDURE source contains only the procedure's body.

Thanks

Andrew



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/