Table Events Order
Posted: Wed Feb 17, 2016 1:10 pm
Hi,
Is there a specific order in the sequence of the table events ?
i.e a foundset with new records and changed records.
Are all new records inserted to the db then all changes committed ?
Are records inserted and updated based on the foundset sort ?
Are all changes committed before and then all new records inserted ?
I'm trying to determine the best scenario to check for duplicate records within a foundset, when this foundset has new and changed records. My db events are not tied to forms foundsets or related foundsets, all is done within queries so new records are currently unreachable when controling duplicates within onRecordUpdate()
In either case I 'd check duplicates by looping through the existing parent children records, checking record.getChangedDatas() for each record in the foundset before committing this new record.
Thanks
Ugo
Is there a specific order in the sequence of the table events ?
i.e a foundset with new records and changed records.
Are all new records inserted to the db then all changes committed ?
Are records inserted and updated based on the foundset sort ?
Are all changes committed before and then all new records inserted ?
I'm trying to determine the best scenario to check for duplicate records within a foundset, when this foundset has new and changed records. My db events are not tied to forms foundsets or related foundsets, all is done within queries so new records are currently unreachable when controling duplicates within onRecordUpdate()
In either case I 'd check duplicates by looping through the existing parent children records, checking record.getChangedDatas() for each record in the foundset before committing this new record.
Thanks
Ugo