Forms 3.0 question

Please help (if possible)!!!!

I have a block containing 1 queryable field and several display-only fields. When I SELECT info from a table into these fields, every thing is OK except when I try to clear or leave the form. The question, "Do you want to commit changes??" pops up. However, if I instead perform the following commands:

    go_block('block_name'); execute_query;

I do NOT get the "commit" prompt when leaving the form. Why is there a difference between these 2 actions? (Keep in mind that none of the fields in the block are user-updateable!!!).

How can I prevent the "commit" prompt from popping up when all that was done was a "query"??

Also, the reason I want to use the SELECT method is that I actually have several blocks which depend on each other. I found that the direct SELECT method is MUCHO faster than going through the succession of "execute_query" calls (which use the criteria in the ORDERING statement in the block definitions.)  

Please e-mail response in addition to posting. Thanks in advance.

Frustrated with Forms!!
Ruth Whitis
whitisr_at_isco.purdue.edu Received on Thu Dec 15 1994 - 21:21:09 CET