I have a database with a SP that contains a SELECT join with an illegal RDB$FOREIGN66
reference; it should be 67.

I've tried using IB 5 and IBConsole to drop or alter the procedure. Interbase dies.

I've tried using FB 1.0 & IB_SQL, but it when I try to save the change I am informed that
RDB$FOREIGN66 is illegal in this context.

FOREIGN66 is the foreign key for an origin suburb into the SUBURB table.
FOREIGN67 is the foreign key for a destination suburb into the SUBURB table.

(How this worked for years I don't know.)

I want to change the 66 to 67.

I've tried doing this directly in the BLR for the procedure in the RDB$PROCEDURE table and
am informed that the type of BLR expected is 4 but it found 98.

What should I do?
--
Raymond Kennington
Programming Solutions
W2W Team B