Re: Form: How to avoid Record_Status change?

>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 ?
>

At the end of the POST-QUERY trigger, call SET_RECORD_PROPERTY(:system.cursor_block, :system.cursor_row, status, query_state)

(Double check the syntax...)

Dan Hekimian-Williams Received on Fri Dec 17 1999 - 03:22:46 CET