title: Oracle forms record status
body: <p>I have an issue that I need to figure out. We're using Oracle forms 6. I've got detailed view of a record in block <code>B2</code> with some fields in it. User is able to create and update that record. But in this block I've got also a button with trigger <code>WHEN-BUTTON-PRESSED</code> on it. When user press the button it goes to another block called <code>B4</code> and executes query. When there are some filled fields in block <code>B2</code> I have to change record property in <code>B2</code>. Block <code>B4</code> opens a new window with canvas in it. User is able to go back to block <code>B2</code> by pressing escape key, close button and by save button. The thing is, that I'm not able to change the record_status back to the state before leaving block <code>B2</code>.</p>
  
  <p>Code sample:</p>
  
  <pre><code>/*
   B2 OPEN_BTN WHEN-BUTTON-PRESSED
  */
  set_record_property(:system.trigger_record, 'B2', STATUS, QUERY_STATUS);
  go_block('B4');
  execute_query;
  
  
  /*
   B4 PRE-QUERY
  */
  --do some stuff (set_default_where, ...)
  
  
  /*
    User modifies one of the records without commit
  */
  
  
  /*
   B4 SAVE_BTN - WHEN-BUTTON-PRESSED
  */
  --assign values to the fields of block B2
  go_block('b2');
  --change the record status back to it's default (INSERT/CHANGED) - but how?
  --I've tried many things and I got sometimes alerts of 
  --invalid change from CHANGED to INSERT etc.
  </code></pre>
  
  <p>Thanks for your help! All should be done without any prompt to save the record.</p>