Just add a trigger to your database to do that calculation on after insert
and update

----------------------------------------------------------------------------

----- Original Message -----
From: "james_027" <james_027@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, June 13, 2003 10:51 PM
Subject: [IBO] calculated field vs computed


> which could be the best practice...
>
> lets take this table for example ...
>
> table 1 has the following column, id, description, qty, price.
>
> I want to put a calculated field for table 1 which is the subtotal
> field.
>
> option 1. in they T_query1.sql I will put select *, "qty"*"price"
> as "subtotal" from "table 1"
>
> option 2. in they T_query1.calculated fields properties will I
> declare the "subtotal" field.
>
> option 3. Iam not so sure if this is possible, under the column
> attributes I will add a new field "subtotal" then check the computed
> check box.
>
> What is the use of the computed attributes under the column
> attributes besides from when we are using it for setting up a
> TIB_lookupcombo
>
> please explain the option you think is the best practice.
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>