| problem saving insert s into a tabular form [message #79916] |
Wed, 24 July 2002 18:49  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
