Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!news.webusenet.com!peer01.cox.net!cox.net!border3.nntp.aus1.giganews.com!intern1.nntp.aus1.giganews.com!nntp.giganews.com!nntp.dsli.com!news.dsli.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 08 Aug 2003 13:09:11 -0500
From: "Dave Williams" <davetati@dsli.com>
Newsgroups: comp.databases.oracle.tools
References: <YvucnQm_Dt6cm6yiU-KYgg@dsli.com> <JroYa.676063$Vi5.15958416@news1.calgary.shaw.ca> <bgtfql$bmb$1@cronkite.cc.uga.edu>
Subject: Re: Oracle Forms: Need advice
Date: Fri, 8 Aug 2003 13:39:07 -0400
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID: <yAGdncCJIfzaeq6iXTWJig@dsli.com>
Lines: 51
NNTP-Posting-Host: 209.42.38.109
X-Trace: sv3-d1pak3qb5s/1AhRuhTx1jUdfow9tsb/LgM4yqhZ5tUvWUwOl+kOXy3gVXwq6XJzPOCfozSO77tcIJzd!1Ts7Nx2tfZ7iwBCNQx5cN92izrF38yPqE4dQyuVT4f4fn68lvYsLDxdrnXHJfEP1SkI=
X-Complaints-To: abuse@dsli.com
X-DMCA-Complaints-To: abuse@dsli.com
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.1
Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:82475

Jeff,

Ok, that is what I was thinking of doing.  I think I'll do this since it
will be easier to control.

Cheers.
"Jeff" <jeff@work.com> wrote in message
news:bgtfql$bmb$1@cronkite.cc.uga.edu...
> In article <JroYa.676063$Vi5.15958416@news1.calgary.shaw.ca>, "Maximus"
<qweqwe@qwqwewq.com> wrote:
> >"Dave Williams" <davetati@dsli.com> wrote in message
> >news:YvucnQm_Dt6cm6yiU-KYgg@dsli.com...
> >> All,
> >>
> >> Need some advice on what the best way to handle the following situation
> >is.
> >>
> >> I have a form that is based upon a DB table.  There are about 4 columns
> >that
> >> are id's and link to other tables.  I have a post_query trigger that
> >obtains
> >> the data from the relevant tables and puts them into text fields on the
> >> form.  So, the id fields are never displayed.  If a query is run and I
> >then
> >> elect to close the form it asks if I want to save the data, assuming
here
> >> that since the data was loaded into text fields Oracle Forms is now
> >thinking
> >> that the data has been modified.
> >>
> >> What I have done in the past is to use the set_record_property in the
> >> post_query table.
> >>
> >> Is there a better way of handling this ?
> >
> >If you modify item values in a block programatically or interactively
after
> >a query, such as during a post-query trigger, you will mark the
block/record
> >status as 'changed' and you will be prompted to save those changes upon
> >exit, that is the way block functionality works.  If you want to simply
> >display values in a form, say programatically from a post-query trigger,
use
> >'display' items instead of 'text' items, this doesn't affect the status
of
> >the block if they are modified.
>
> Alternatively, if for some reason you don't want to use display items, you
> could move these never-updated text items to a non-database control block.