saving a block based on view [message #82644] |
Mon, 16 June 2003 23:42 |
d2k-programmer
Messages: 16 Registered: May 2003
|
Junior Member |
|
|
Hello expert !
I have created a detail block base on a view,
let's say the view
create or replace view vw1 select masterfile.*,transactionfile.*...............
how can i save the transaction file in this detail block ?
thanks
d2k-programmer
|
|
|
Re: saving a block based on view [message #82645 is a reply to message #82644] |
Tue, 17 June 2003 00:09 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
From the top of my head: if the view is updateable, Forms will accept the DML without any problem. If not, you should either create your own ON-UPDATE, ON-INSERT and ON-DELETE triggers for the block or change the key mode of the block to UPDATEABLE and assign a primary key item.
IMHO, I think you should go for the first option. Because the second one could also involve creating INSTEAD OF database triggers.
MHE
|
|
|