| Subject | Re: [firebird-support] stored procedure for a computed field? |
|---|---|
| Author | Thomas Steinmaurer |
| Post date | 2014-03-27T08:09:55Z |
Hi!
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.
> I have a stored procedure to calculate an indication of a record's age.As Martijn has pointed out, it is definitely possible. ;-)
> 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?
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.