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
(SOLVED) Loosing data using multiple joins in checkboxes
(SOLVED) Loosing data using multiple joins in checkboxes
Last edited by jannes on Tue May 19, 2020 9:45 am, edited 1 time in total.
Re: Loosing data when using multiple joins in checkbox-scree
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
Bruce
Re: Loosing data when using multiple joins in checkbox-scree
Yes, the records are physically deleted in the REF-tables.
= Jannes
= Jannes
Re: Loosing data when using multiple joins in checkbox-scree
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
Bruce
-
- Posts: 7523
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Loosing data when using multiple joins in checkbox-scree
There were a couple of bugs related to checkbox lists. Use the latest build 2722 that fixes some of them
Aware IM Support Team
Re: Loosing data using multiple joins in checkboxes (SOLVED)
The issue is solved by (thnx to Vlad) :
1. Update to the latest Aware IM build 2722 (if not done already)
2. Download the file
https://awareim84.s3.amazonaws.com/awareim.jar
3. 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)
4. Download the file
https://awareim84.s3.amazonaws.com/aware.js
5, Put this file in AwareIM/Tomcat/webapps/AwareIM/aware-kendo directory overriding the original
Restart Aware IM
6. Clear browser cache and refresh the browser
= Jannes
1. Update to the latest Aware IM build 2722 (if not done already)
2. Download the file
https://awareim84.s3.amazonaws.com/awareim.jar
3. 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)
4. Download the file
https://awareim84.s3.amazonaws.com/aware.js
5, Put this file in AwareIM/Tomcat/webapps/AwareIM/aware-kendo directory overriding the original
Restart Aware IM
6. Clear browser cache and refresh the browser
= Jannes