Home » Developer & Programmer » Forms » problem saving insert s into a tabular form
problem saving insert s into a tabular form [message #79916] Wed, 24 July 2002 18:49 Go to next message
Messages: 11
Registered: February 2002
Junior Member
I am trying to save the contents of a tabular form after populating it from the table.I need to save only the new record.The problem is my old records are also getting inserted agig because I populate them from he table.My code is as follows

cursor c1 is Select x,y,z from table where a=b
open cusror;
If :system.record_status !new then
End if;
Fetch C1 into :blk.item_name, :blk.item_name, :blk.item_name
exit when C1%Notfound
End Loop;
Close C1;
Re: problem saving insert s into a tabular form [message #79933 is a reply to message #79916] Fri, 26 July 2002 06:28 Go to previous message
Ranjit Bisoyi
Messages: 18
Registered: November 2001
Junior Member
your question is vague..still i m telling u wht i understood.

You can do it in many way.
Instead of :system.record_status != 'NEW' PLS Try with
If :system.record_status = 'CHANGED' or 'INSERT'.

As Record_Status had CHANGED, NEW, INSERT, QUERY properties, when u get them from a table, they are in QUERY STATUS.
Previous Topic: Restricting user not to create more than one record in a multi record block
Next Topic: Oracle- Access
Goto Forum:

Current Time: Tue Nov 30 12:14:04 CST 2021