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
Irene
Messages: 11
Registered: February 2002
Junior Member
Hi,
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
G)_block('Test);
open cusror;
Loop
If :system.record_status !new then
Create_record;
End if;
Fetch C1 into :blk.item_name, :blk.item_name, :blk.item_name
exit when C1%Notfound
first_record;
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
Hi,
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