Re: Form: How to avoid Record_Status change?

From: <kphuong_at_my-deja.com>
Date: Thu, 16 Dec 1999 10:15:58 GMT
Message-ID: <83ae4s$l40$1_at_nnrp1.deja.com>


It works! Thank you very much, Dana.



In article <839tio$88f$1_at_nntp6.atl.mindspring.net>,   "Dana Alcivare" <nospam_at_nowhere.com> wrote:
> yes, you can use set_record_property. you can place it in the
> same post-query trigger. here's some pseudo-code:
>
> declare
> cur_rec VARCHAR2(100) := :System.Trigger_Record;
> cur_block VARCHAR2(100) := :System.Trigger_Block;
> begin
> <do your normal post-query stuff>
> set_record_property(cur_rec,cur_block,STATUS,QUERY);
> end;
>
> i don't remember if that's the correct order/options for
set_record_property
> but that should point you in the right direction. i know this works in
> dev6...
> i'm assuming previous versions have similar functionality.
>
> dana
> alcivare_at_mindspring.com
>
> kphuong_at_my-deja.com wrote in message <839r2j$7uk$1_at_nnrp1.deja.com>...
> >Hi all,
> >I have this form:
> >- Block ORD based on table ORD (orders)
> > - Item CUSTOMER_ID based on column CUSTOMER_ID
> > - Item CUSTOMER_NAME is a non database item
> > - Trigger POST-QUERY of block ORD populates CUSTOMER_NAME from
the
> >value of CUSTOMER_ID.
> >
> >The problem is, POST-QUERY trigger makes the record status change to
> >'CHANGED'. Therefore the form asks me "Do you want to save changes?"
> >each time I enter-query or quit, even if I don't make any
modification
> >to other items.
> >
> >Can you pls help me to avoid this message?
> >Thank you very much for this.
> >
> >P.S. Can I use Set_Record_Property to reset the record status back to
> >'QUERY' ? If so, what trigger should I put the code in ?
> >
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 16 1999 - 11:15:58 CET

Original text of this message