good question - they're all valid ways
I try to be consistent whichever way I start.
My gut has been:
generally where the calculation is done once per record, the server is a
good place
if the record is going to continue to get edited via UI and recalced I let
the frontend do all calcs
I use a select method to calc only where I am building a readonly browse
grid with values for say summaries

Alan

-----Original Message-----
From: Martin D. Berezaga [mailto:mdberezaga@...]
Sent: Wednesday, 11 December 2002 10:40 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] Calculated Fields


Which would be the vantages/disvantages using the followings approaches to
implement calculated fields?

1. Calculated field implemented on the database with COMPUTED BY clause.
2. Get the calculated value with an expression in the SELECT clause.
3. Implement the calculated field in the client application.

Thanks.

---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------

_______________________________________________________________________
Busca Yahoo!
O melhor lugar para encontrar tudo o que vocj procura na Internet
http://br.busca.yahoo.com/


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/