Post reply

inserting and deleting in views

  • June 15, 2004 at 3:43 am

    #108399

    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

    #510412

    i just solve it by using instead of in the trigger. hehehe thanx me. any alternatives? thanx

  • June 16, 2004 at 1:35 am

    #510590

    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 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply