Subject | Computed by fields with function F_Ageindays can not be dropped or modified in V 2.5 |
---|---|
Author | |
Post date | 2013-10-10T01:02:56Z |
When you try to modify a “computed by” field, by changing F_AGEINDAYS( to DATEDIFF(day (which result in the same value), using IBEXPERT, it returns success, but when you try to commit the changes, then it shows the message:
invalid request BLR at offset 125
function f_ageindays is not defined
module name or entry point could not be found
-----
Changes will be rolled back
Function F_Ageindays has been deleted, but it was there, it was also NOT possible to do this even prior to deleting f_ageindays. It would issue the same “module name or entry point could not be found”.
The thing is that the dll file is 32-bit and the operating system and Firebird 2.5 is 64-bit, too. The database was migrated from V 2.0 to V 2.5 with very special switches using gbak from version 2.5.
gbak did not complain about the functions.
Other views and procedures that did use f_ageindays were edited with the datediff syntax and were recompiled with no problems. It is then computed by fields that can't be modified or dropped, due to probably a trigger (?) hidden there, somewhen, that won't allow the operation to take place.
It doesn't make much sense (the error given), since function f_ageindays should not be part of what the deletion and recreation of the “computed by” field requires.