APEX

Using Oracle 11.2 and Apex 4.1.
1. I'm using a form on a table with buttons: QUERY, INSERT, DELETE and CANCEL.
2. After INSERT and DELETE, the form is cleared.
3. But I'd like to clear the form after QUERY. Well, I'd like to clear it when the user wants it cleared!
4. And, in fact, I have a Clear Cache process for the CANCEL button.
5. When I click CANCEL, there is a flash as the screen repaints.
6. And what I believe is happening, is that after the cache is cleared, the RCD_ID page variable has the prior value and the "Fetch Row from table" processing is retrieving the record once more.
7. So I have the values back that I wanted cleared! Seems like I'm being dogged by the ARF functionality. (ARF, ARF!)

1. I tried changing the "Go to page nn" to clear cache for the page but that seemed to make no difference.
2. I tried setting the RCD_ID page variable to '' as I do after DELETE but that didn't work for CANCEL either.

Thoughts?

I guess it's just me but the extremely annoying part of APEX is that some obvious simple things -- like clearing the form -- have no obvious simple solution. I should clarify, there are a couple of obvious approaches, but none seem to work. One would think that a CLEAR button would be a standard button or that CANCEL had an option to clear the form and or clear a list of items on the page.

Howard