Results 1 to 4 of 4

Thread: nested insert?

  1. #1
    Join Date
    Feb 2003
    Posts
    2

    Unanswered: nested insert?

    Can this be done? a nested instert in a trigger or stored proc?

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    Explain

  3. #3
    Join Date
    Feb 2003
    Posts
    2
    Originally posted by ispaleny
    Explain
    I need to insert several checkbox responses into a table, but the only thing that I can think of doing is using a trigger that will will do an insert ofr the first record and then trigger another insert for the next record. But I cannot find anyone on the web that seems to know if that can be done... please let me know or give a little example of how this coul dbe done. thanks

    greg

  4. #4
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    ??????
    You have several pieces of data in the front end that you want to get into a database - one piece of data per record?

    If you insert the first and use a trigger for the rest how is the database going to know what data to insert - it only knows about the datat for the record inserted.

    Easiest is to call the insert SP several times from the front end - once for each record - maybe in a transaction.

    You could also send a csv lst to the sp in one call and have the SP then do all the inserts.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •