Re: Values depending on other values

Hi Daniel, thanks for your reply.

The situation is :

• I've got a table with records (each record is a state of a sensor).
• I've got a form that reads those records and can add more.

What I have to do:

• Users must be able to insert records with the current value of the sensor (easy).
• Users must be able to insert records which values depends on other sensors. The value of each of theese sensor is an equation which variables are the values of other records.

I think I have two problems:

• How could I give the user an equation editor to write the equation whitout knowing SQL. Anyone knows any SQL equation editor?
• How could I do to have the records up to date?

Thanks again, I think this is not a very easy issue.....

"Daniel Morgan" <damorgan_at_x.washington.edu> escribió en el mensaje news:1074077757.364844_at_yasure...
> NegreT wrote:
>
> > Hi all,
> >
> > I have to insert some rows in a database and some values in this rows
> > depends on the values of other rows in the database.
> >
> > This new value must continue up to date dependig on the value of the
> > origin data.
> >
> > ¿How could I do this? I´ve been thinking of using triggers that update
> > the variable values but, is there any other way?
> >
> > Thanks in advance
>
> You should almost never store the result of a calculation in a
> relational database. Why not calculate the value on the fly for display
> on screen or in reports?
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Wed Jan 14 2004 - 09:44:51 CST