Re: Forms 4.5:Do you want to save changes?

You probably have POST_QUERY TRIGGER on one of your BLOCKS Whenever you query that block or item it changes it's value which causes message:
"Do you want to save chances?"

To avoid this use this:

1. Use VIEWS instead of joining two tables
2. Put the following code in your POST_QUERY trigger:

record_id := to_number(:system.cursor_record); set_record_property(record_id,'<BLOCK_NAME>',STATUS,QUERY_STATUS);

Vitaliy Mogilevskiy Received on Tue Feb 16 1999 - 12:54:26 CST