Path: news.easynews.com!easynews!peer1-sjc1.usenetserver.com!usenetserver.com!sn-xit-04!sn-xit-02!supernews.com!postnews1.google.com!not-for-mail From: mgazge@hotmail.com (Ali) Newsgroups: comp.databases.oracle.tools Subject: Re: Calculated item doesn't get updated to database Date: 3 Mar 2002 04:53:32 -0800 Organization: http://groups.google.com/ Lines: 34 Message-ID: References: <4c29054a.0202270828.1f1e0e66@posting.google.com> <3C7D2CD4.8640C37D@ci.seattle.wa.us> <4c29054a.0202272121.76acc351@posting.google.com> NNTP-Posting-Host: 195.229.245.69 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1015160012 6456 127.0.0.1 (3 Mar 2002 12:53:32 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 3 Mar 2002 12:53:32 GMT Xref: easynews comp.databases.oracle.tools:49292 X-Received-Date: Sun, 03 Mar 2002 05:51:26 MST (news.easynews.com) 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@yahoo.com (Av) wrote in message news:<4c29054a.0202272121.76acc351@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 wrote in message news:<3C7D2CD4.8640C37D@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