🚀 go-pugleaf

Frank Gruber wrote:
>> This is done easy with many of the tools (IBExpert.com for example)
>
> Which I currently use but which does not solve my problem in this
> case. I need to supply a tool for our customers which they can use to
> update their db to a newer release our new software requires. So I
> have to do it programatically and I don't want to include the whole
> source of all depending SP.
>
> Regards,
> Frank.

Open SQL monitor from Tools, then run Recompile all strored procedures from
DataBase menu and will see what code
IBExpert actualy use.

Here one of mine:

select pr.rdb$procedure_name,
pr.rdb$procedure_source,
pp.rdb$parameter_name,
pp.rdb$parameter_type,
fs.rdb$field_name,
fs.rdb$field_type,
fs.rdb$field_length,
fs.rdb$field_scale,
fs.rdb$field_sub_type,
fs.rdb$segment_length,
fs.rdb$dimensions,
cr.rdb$character_set_name,
co.rdb$collation_name,
pp.rdb$parameter_number,
fs.rdb$character_length
,FS.RDB$FIELD_PRECISION
from rdb$procedures pr
left join rdb$procedure_parameters pp on pp.rdb$procedure_name =
pr.rdb$procedure_name
left join rdb$fields fs on fs.rdb$field_name = pp.rdb$field_source
left join rdb$character_sets cr on fs.rdb$character_set_id =
cr.rdb$character_set_id
left join rdb$collations co on ((fs.rdb$collation_id = co.rdb$collation_id)
and
(fs.rdb$character_set_id = co.rdb$character_set_id))
where pr.rdb$procedure_name = 'COPY_MATERIAL_TYPE'
order by pp.rdb$parameter_type, pp.rdb$parameter_number

Then it forms standart header Alter Procedure with the params and after that
the source of procedure.


--
Bojidar Alexanrov
Kodar Ltd.
http://www.Kodar.net