(SOLVED) Loosing data using multiple joins in checkboxes

jannes

Hi,

There are 3 tables :
• Customer
• Company
• Manufacturer

Customer can have multiple Company
Customer can have multiple Manufacturer
Manufacturer can have multiple Customer
Manufacturer can have multiple Company
Company can have multiple Manufacturer
Company can have multiple Customer

All relations are Peer / multiple allowed

Checkbox Widgets are used so the user can easily define relations.

But entering data in one screen, data is lost in other tables.
Records are simply deleted in other tables.
For instance : entering Customer-Manufactur relations will delete data in Customer-Company..

Is it a known issue / bug ?
Or do I have to store the relations in tables like CustomerCompany, ManufacturerCustomer etc.. ?

= Jannes

BLOMASKY

You have Many to Many relationships. To handle that, Aware will create a 3rd table which is used to relate the two tables. This new table ends in "_REF". So you can examine that table and see if rows are being deleted. I use them with pick lists to select the "related" records and have not had any problem.

Bruce

jannes

Yes, the records are physically deleted in the REF-tables.

= Jannes

BLOMASKY

I would love to see a sample BSV that causes this. I have not had this issue and if it is because of the aware engine, would be nice to know sooner rather than later.

Bruce

aware_support

There were a couple of bugs related to checkbox lists. Use the latest build 2722 that fixes some of them

jannes

The issue is solved by (thnx to Vlad) :

Update to the latest Aware IM build 2722 (if not done already)
Download the file https://awareim84.s3.amazonaws.com/awareim.jar
Put this file into the following directories
a) AwareIM/lib
b) AwareIM/Tomcat/webapps/AwareIM/WEB-INF/lib
overwriting the original files (keep the originals somewhere just in case)
Download the file https://awareim84.s3.amazonaws.com/aware.js
Put this file in AwareIM/Tomcat/webapps/AwareIM/aware-kendo directory overriding the original
Restart Aware IM
Clear browser cache and refresh the browser

= Jannes