Hi guys,
First let me tell you, you built a great tool. However I think I ran into a serious bug.
I made a form with editable repeating groups. I made a pre-filter on the list to only show records that are not referenced by a third table, Like ?repeatedgroup.PK NOT IN Select FK FROM third table?.
When I open de edit screen with the repeating groups don?t change anything and press the submit button, all records that were filtered out by the Pre-filter, are deleted.
After I noticed this, I put a Restrict constraint in MYSQL on the FK of the third table to the id of the repeated group id. When I try now to open and submit de form I get an error:
?SQL=DELETE FROM repeated group table WHERE repeated group.FK = main table.id and ! ( repeated group.id IN (13,4,6,7,3,2,23))?, which are only the id?s of de repeating group records that are displayed. So only the displayed records are excluded from deletion and the records that are not shown would be all deleted if the constraint was not there.
Can you please fix this or tell me how I can work around this?
First let me tell you, you built a great tool. However I think I ran into a serious bug.
I made a form with editable repeating groups. I made a pre-filter on the list to only show records that are not referenced by a third table, Like ?repeatedgroup.PK NOT IN Select FK FROM third table?.
When I open de edit screen with the repeating groups don?t change anything and press the submit button, all records that were filtered out by the Pre-filter, are deleted.
After I noticed this, I put a Restrict constraint in MYSQL on the FK of the third table to the id of the repeated group id. When I try now to open and submit de form I get an error:
?SQL=DELETE FROM repeated group table WHERE repeated group.FK = main table.id and ! ( repeated group.id IN (13,4,6,7,3,2,23))?, which are only the id?s of de repeating group records that are displayed. So only the displayed records are excluded from deletion and the records that are not shown would be all deleted if the constraint was not there.
Can you please fix this or tell me how I can work around this?