Hello all, I have two procedures:
ProcA and ProcB where ProcB calls ProcA. I have made the altering of ProcA because of bugfix and I haven't touched the ProcB, because it was OK. When I was getting the results from ProcB, it still haven't returned me as I wanted and then I've got the results from ProcA for test I saw, that ProcA returns correct values and ProcB still return wrong values based on old version of ProcA. Therefore I think I have to call "alter procedure ProcB" as well to get ProcB working with actual version of ProcA. OK, this is a very simple example, but the relations are much wider and deeper. How can I force Firebird to rebuild all procedures without backup/restore? Do you have any trick how to easily rebuild them? -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk