PDA

View Full Version : Insert records into multiple tables?


cheongyap254819
06-07-2009, 02:06 AM
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?

Joe Lowery
06-07-2009, 08:24 AM
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

cheongyap254819
06-07-2009, 11:00 AM
Thanks. This helps me a lot.