Using v17r3, Mac: I have a listbox that displays a selection of records from the [ListItems] table, which are related to a record in the [Lists] table. User can select an item in the list and click the Delete button to delete a [ListItem] record. The code that runs:
*USE SET*("ListboxSet0") *DELETE SELECTION*([ListItems]) *QUERY*([ListItems];[ListItems]ListNumber=[Lists]RecordNumber) *ORDER BY*([ListItems];[ListItems]ItemText) What happens is that after the ORDER BY line, the selection of [ListItems] records changes. For example: Click Delete button: there are 51 ListItems selected *USE SET*("ListboxSet0") now one ListItem is selected *DELETE SELECTION*([ListItems]) 0 ListItems selected *QUERY*([ListItems];[ListItems]ListNumber=[Lists]RecordNumber) 50 ListItems selected *ORDER BY*([ListItems];[ListItems]ItemText) Now there are 12 ListItems selected! The same thing occurs if a new record is added to ListItems. Note that this running inside a transaction. If I insert VALIDATE TRANSDACTION after deleting or adding a record, it all works correctly. But I don't want to validate the transaction at that point, and I don't understand why that would be necessary. Bug? PB -- ************************************************* CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************