Subject | Dynamic DDL in user apps, was Re: [firebird-support] Re: Firebird SS-1.5.1 and RedHat ES 4 troubles |
---|---|
Author | Helen Borrie |
Post date | 2006-02-24T09:52:23Z |
At 06:56 PM 24/02/2006, you wrote:
app. There are two better (safer, quicker, testable) ways to do this
sort of thing.
1) Defined the computed fields permanently (they'll never be
calculated unless you include them in SELECT statements)
or 2) (better)
2) create views containing the computed fields you want for reports, etc.
./heLen
> >It sounds even more wrong to be altering the table from your
> > WHY is your application code performing dynamic DDL at all?
> > Because sometimes we require to show some computation on some reports
> > to a lot of client and this was the simplest and quickest way without
> > involving other application layer.
> >
app. There are two better (safer, quicker, testable) ways to do this
sort of thing.
1) Defined the computed fields permanently (they'll never be
calculated unless you include them in SELECT statements)
or 2) (better)
2) create views containing the computed fields you want for reports, etc.
./heLen