Re: Form: How to avoid Record_Status change?

[Quoted] 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 [Quoted] 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.
Received on Thu Dec 16 1999 - 06:34:26 CET