June 15, 2004 at 3:43 am
how do you perform insertion and deletion in views?
i have 2 tables namely newapplication and payments. i use view to query the tables and to allow selected fields to appear. however, whenever i perform insert or delete statement it generates an error. any solution for this? thanx
June 15, 2004 at 4:08 am
i just solve it by using instead of in the trigger. hehehe thanx me. any alternatives? thanx
June 16, 2004 at 1:35 am
You could use stored procedures for insert / delete / update on the view.
Of course this will be row by row processing, since the sp's would be called once for each row.
Actually this row by row processing is done in the IOF Trigger now, right?
/rockmoose
You must unlearn what You have learnt
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply