Home » Developer & Programmer » Forms » how can hide the deleted marked record.
how can hide the deleted marked record. [message #78664] Fri, 08 March 2002 21:57 Go to next message
Rajesh Mandawat
Messages: 37
Registered: October 2001
Member
Hi

When I am deleting the record I using the command delete record . But deleted record is
Showing during query. Unless I use the

Delete_record;
Commit_form;

After commiting the form it will permanently remove the record. what should I do so that deleted record can not be seen.

Rajesh
Re: how can hide the deleted marked record. [message #78684 is a reply to message #78664] Mon, 11 March 2002 00:09 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
try this way

Delete_record;
post;

Writes data in the form to the database, but does not perform a database commit. Oracle Forms first validates the form. If there are changes to post to the database, for each block in the form Oracle Forms writes deletes, inserts, and updates to the database.

Any data that you post to the database is committed to the database by the next COMMIT_FORM that executes during the current Runform session. Alternatively, this data can be rolled back by the next CLEAR_FORM.
Previous Topic: Report calling from forms clarifications
Next Topic: exec database procedure........
Goto Forum:
  


Current Time: Tue Apr 23 15:45:45 CDT 2024