dcsimg
Results 1 to 4 of 4

Thread: INSERT data into 2 or more tables

  1. #1
    Join Date
    Dec 2002
    Location
    Albany, NY
    Posts
    115

    INSERT data into 2 or more tables

    Frank,

    How do we use the .dbEditUpdateSQL and .dbEditAddSQL to INSERT data into 2 or more tables?

    An example would go a long way...

  2. #2
    Join Date
    Oct 2002
    Posts
    933
    I got the old classic example converted to Tornado and working. I found out that there is a simpler way to do it and also give user better control. If you are in a a rush.. send me an email to get the code or wait till I get the easier example going.


    FK

  3. #3
    Join Date
    Dec 2002
    Location
    Albany, NY
    Posts
    115
    Frank, I'll be out of the office this week so I won't be needing the code until next week ,6/21/2004. Will you have the code available by then?

    As usual, you have provided excellent support for the ASPdb product. Thank you!!!!

  4. #4
    Join Date
    Oct 2002
    Posts
    933
    I already sent you the conventional way to do it. example is in the updated manual (bottom). The easy way is to just build an input form that includes the 2 or multiple tables and then intercept the submitted values and the do an execute silentcmd. This way, user have complete control. Seems like a good idea anyway... when I have time, I'll try that.


    Frank

Posting Permissions

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