Hi! > I have a stored procedure to calculate an indication of a record's age. > It return "over 100 days ago" or "over 3 months ago" or ... Call it > GetAgeMsg(myTS). > Can I use a stored procedure to calculate a computed field for FB 2.5.x? > If so what is the syntax?
As Martijn has pointed out, it is definitely possible. ;-) But to be on the safe side, I would try a backup/restore cycle with gbak to see if that SP dependency in a COMPUTED BY field causes troubles from a dependency POV. AFAIR, this has been fixed in 2.1, but I would give gbak a test-drive on that, otherwise you might end up with non-working backups. Just a thought. -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.