There are many fileds to be calculated.
In this table are stored values for some persons,between 2 calculations persons could be added or deleted so there will be new or deleted records.
Thanks





----- Original Message ----
From: Alan McDonald <alan@...>
To: firebird-support@yahoogroups.com
Sent: Saturday, August 30, 2008 10:09:21 AM
Subject: RE: [firebird-support] Delete advice

> Hi !
> I have an old application that works with .mdb file and I have to
> rewrite it and this time I'll use Firebird for data storing.Application
> does some calculations in one table,method used : delete every row and
> add new calculated rows,calculation is done several times on a day.I
> think this will grow my database and I don't like this way and I plan
> to use one field active_,to set 0 before calculation, then I'll use
> Update or Insert with active_=1 and finally I'll delete only rows with
> active_=0.
> Am I doing right this way?
>
> Thanks for any advice.
>

and why don't you use a calculated column
or
just update rows with a calculated value?
Alan






[Non-text portions of this message have been removed]