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.