Re: Calculated item doesn't get updated to database

Calulated items are display-only items. Cannot be updated in the database. If you need to update the items, then you would have to reference it like you have done.

avril7_at_yahoo.com (Av) wrote in message news:<4c29054a.0202272121.76acc351_at_posting.google.com>...
> Yes, the calculated field is also a database field. I tried using
> another item that would reference the calculated item, and then store
> it in the database, ut it was difficult to update the item when the
> calculated item changed.
>
> damorgan <dan.morgan_at_ci.seattle.wa.us> wrote in message news:<3C7D2CD4.8640C37D_at_ci.seattle.wa.us>...
> > Is there a field for the data in a table? Is there anything connecting the
> > two?
> >
> > Daniel Morgan
> >
> >
> >
> > Av wrote:
> >
> > > In my form, I created a database text item named print_order in a
> > > multi record block. It has the the following properties:
> > > Calculation Mode: Formula
> > > Formula: GET_BLOCK_PROPERTY('MICRB',CURRENT_RECORD)
> > >
> > > On the screen it updates correctly (in conjunction with RECALCULATE)
> > > when records are created and deleted. But when I commit to the
> > > database, the print_order column is empty! Is there something else I'm
> > > missing?
> > >
> > > Your help would be greatly appreciated.
> > >
> > > Thanks
> > > Av
Received on Sun Mar 03 2002 - 13:53:32 CET