Subject | Problem with reserved words and going from IB5.6 to 6 |
---|---|
Author | john@equatorIT.com |
Post date | 2001-11-07T21:13:36Z |
Hi all,
Whilst using IB5.6 there was no problem in using procedures with
names like DAY, MONTH, YEAR etc.
When I found IB6 did not like these procedure names, I distributed
updates that dropped the procedures and renamed them whilst running
IB5.6
I now find one of my customers has updated to IB6 before updating the
procedures. The restore worked ok, but now I cannot drop the
procedures with the reserved word (name).
So I do not have a backup of the database other than from IB6.
Any suggestions about how I can drop / rename the procedures?
Thanks in advance
John Newcombe
john@...
Whilst using IB5.6 there was no problem in using procedures with
names like DAY, MONTH, YEAR etc.
When I found IB6 did not like these procedure names, I distributed
updates that dropped the procedures and renamed them whilst running
IB5.6
I now find one of my customers has updated to IB6 before updating the
procedures. The restore worked ok, but now I cannot drop the
procedures with the reserved word (name).
So I do not have a backup of the database other than from IB6.
Any suggestions about how I can drop / rename the procedures?
Thanks in advance
John Newcombe
john@...