ListGrid Update (Joining 2 Table)

[wonderman882]

Version: Power Edition 2.3 – Build 2010.10.20

I have a ListGrid A which combine Table X & Table Y (Both provide the primary Key) into it.

There is no any problem on fetching the data by using select & join sql statement.

However, if I want to update the record. It told me that I should set "allowMultiUpdate" on OperationBinding.

I would like to ask... how can I handle on this issue? In fact I want to update one table only.

[Isomorphic]

Updating just one table (whatever table is declared as dataSource.tableName) is the default behavior and does not require any configuration. This message about "allowMultiUpdate" actually suggests an unrelated issue: the primary key for the main table is missing from your "update" dsRequest.

[peterunivex]

What about if I want to update all the tables in the join? Presently only the one table is updated, which in the following scenario is "ACCOUNT".

In my setup I have Account joined to Contact_Information joined to Address.

How do I update both the Account table and the Address table in a single form?

My operation binding for update is -

operationType:"update",
customCriteriaFields:"ACCOUNT,SALES_CONTACT,CONTACT,ADDRESS",
customValueFields:"ADDRESS,CONTACT,SALES_CONTACT,ADDRESS1,ADDRESS2,PHONE_NO,FAX_NO",
tableClause:"account,contact_information,address",
whereClause:"account.SALES_CONTACT = contact_information.CONTACT AND contact_information.ADDRESS = address.ADDRESS AND ($defaultWhereClause)"