INSERT data into 2 or more tables

[paul mancuso]

Frank,

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

An example would go a long way...

[Frank]

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

[paul mancuso]

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!!!!

[Frank]

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