Hi,
I have 2 database blocks....the first one includes books registered (emp_no, book_name... and other information for this book)
the second block includes the employee information (name, hire_date... etc)
the relationship is created between both blocks using the employee no...
the user is allowed to insert,update and delete records in the first block and according to the current record employee no, his information should be populated to the second block.
now i have one issue, i have set the insert, delete and update property for the second block to 'No'. when I navigate from different records in the first block the data is populated correctly in the second one. in the other hand, it does not when i insert a new record in the first block (logically correct since the record is not yet saved)
so i thought about creating a post_change trigger on the emp_no item level and there I select the information from DB into the second block.
it works fine, but when i tried to save the information updated/ inserted i got the following error:
ORA-01732: data manipulation operation not legal on this view
this is because that i insert into a data block which is not allowed to be inserted. How can I achieve the requirements??
I tried to set the data block insert to 'Yes', and change the enabled property for each item to be 'No' but the field is grayed in a way that the data is not so clear; so i dont need to use this way.
Is there any alternative?
I am thinking to change it totally into non database block
Thanks alot
Edited by: HST on Mar 27, 2010 6:25 AM