Subject | I can't Backup/Restore a FB 2.01 database after creating it using a nScript |
---|---|
Author | marc_guillot |
Post date | 2007-03-14T19:30:12Z |
Hello.
I creates a FB 2.01 using an Script (so I'am sure it's not corrupted),
but it fails in backup/restore.
gbak finishes Backup with no problem, but when restoring I get an
error of FLOOR (from ib_udf.dll) not registered.
¿ In FB 2.01 there is not possible to backup/restore a database that
uses udf's into their computed fields ?.
I uses FLOOR udf, in a computed field who calculates the age of a
person (from his birthday), if somebody knows anyway to calculate it
without using udf's, i could avoid the problem.
COMPUTED BY (cast(floor((current_date-cast(CLI_BIRTHDAY as
date))/365.25) as integer))
Thank you.
I creates a FB 2.01 using an Script (so I'am sure it's not corrupted),
but it fails in backup/restore.
gbak finishes Backup with no problem, but when restoring I get an
error of FLOOR (from ib_udf.dll) not registered.
¿ In FB 2.01 there is not possible to backup/restore a database that
uses udf's into their computed fields ?.
I uses FLOOR udf, in a computed field who calculates the age of a
person (from his birthday), if somebody knows anyway to calculate it
without using udf's, i could avoid the problem.
COMPUTED BY (cast(floor((current_date-cast(CLI_BIRTHDAY as
date))/365.25) as integer))
Thank you.