Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › How can I get Multiple Insert, Update, Delete with MRT all working together??

View all replies to this thread

How can I get Multiple Insert, Update, Delete with MRT all working together??

Thread began 5/12/2010 1:44 pm by troyd | Last modified 5/17/2010 5:08 pm by troyd | 1985 views | 9 replies

5/14/2010 8:31 pmtroyd

Thanks Eric,

Yes, I am testing it and so far it works. I basically have a second window open, looking at the tables in phpMyadmin while I insert new Sub Categories. I do see 1 new single record in the main Sub Categories table, as it should be. And multiple related records in the relational table displaying the matching foreign key ID. Then, when I delete the Sub Category, it removes all records in both tables.
After hundreds of tests, not seeing the records removed from the relational table, I can't tell you how excited I was when I finally watched them disappear. I won't move this to the live site until I am sure, but so far so good.

TroyD

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.