Inserting new record in Oracle forms
Posted on 2006-04-10
I am new to Oracle forms and am faced with a problem. For records of a certain type, instead of updating the current record with the values in the form items, I am creating a new record in the table with the same values, but with a new sequence number (the primary key is a combination of the code and sequence number) . I can get this to work by using an insert statement in the on-update trigger at the form level. The table is updated, however,the form does not show this new version of the record. It still shows the previous one. How can I get the form to show this recently inserted record? I could set the where clause in the block property to the code and sequence number of the new record and do an execute_query so it displays on the form, but then the user would not be able to scroll up and down to view the other records.