Page 1 of 1
Update several table from one page
Posted: Sun Sep 20, 2015 3:49 pm
by Hwasly
Hi.
I have purchased ASP.Net maker and i want to ask if the above subject is available on it or any tips/ticks to do it.
I have a different tables for employee information and i want to put them in one page as tabs or wizard to make it easy for user entity.
Please advice?
Re: Update several table from one page
Posted: Wed Sep 23, 2015 12:30 pm
by motfs
You can not update more than one table. However, you can make use of the UpdateTable property in the Row_Inserting server event to insert into the main table. For example:
UpdateTable = "<MainTable>";
Just make sure that only the fields from the main table is selected for insert.
Then, you can execute your insert statement (ew_Execute(INSERT ***)) to other tables in Row_Inserting server event. See Server event and Client script in help file.
Re: Update several table from one page
Posted: Thu Sep 24, 2015 5:42 am
by Hwasly
Thanks for your response.
I believe that this won't work with different tables. It is ok with one or two table.
i am disrupting employee information on several tables so i need to use different way.
Re: Update several table from one page
Posted: Thu Sep 24, 2015 9:35 am
by Webmaster
Try setting up as master/details using the employee table as the master. You can then perform master/detail add/edit on the employees table and the related tables.