Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Insert records into multiple tables?

Insert records into multiple tables?

Thread began 6/07/2009 2:06 am by cheongyap254819 | Last modified 6/07/2009 11:00 am by cheongyap254819 | 2816 views | 2 replies |

6/07/2009 2:06 am | #1 cheongyap254819

Insert records into multiple tables?

Hi, I'm newbies to Dataassist.
Just wanna ask is it possible to inject records into multiple tables in Dataassist at the same time?
I realised data assist only allow 1 table insert at a time.

How about if i'm dealing with Relational Database that uses foreign keys.
means i do have to insert the record 1 table by 1 table?

6/07/2009 8:24 am | #2 Joe Lowery

One of the differences between the server behaviors in DataAssist and the standard Dreamweaver ones is that with DataAssist, there is no limitation to the number of insert, update or delete server behaviors you can add to a page. So you can add one DataAssist Insert Record behavior for one table and another for a second table.

On relational tables, DataAssist contains a dedicated server behavior called Manage Relational Tables intended just for that situation.

Best - Joe

6/07/2009 11:00 am | #3 cheongyap254819

Thanks. This helps me a lot.

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.