I'm updating an SQL Server table and a duplicate collection of that table in one button. When I press it, the app is stuck in an infinite loop with the dots passing the top of the screen and the button remains grey. I tested the UpdateIf functions for the SQL and Collection independently and the collection update works without issue. When I restart the app it shows that my SQL update went through, so the SQL part apparently worked, but is causing an infinite load. The table and collection are ~4,500 records long each. Below is the logic.
UpdateIf( '[dbo].[SQL_TABLE]', TABLE_ID in TableCheckedItems.TABLE_ID, {FOREIGN_KEY_ID: ComboBox27_1.Selected.FOREIGN_KEY_ID} ); UpdateIf( SQL_TABLE_COLLECTION, TABLE_ID in TableCheckedItems.TABLE_ID, {FOREIGN_KEY_ID: ComboBox27_1.Selected.FOREIGN_KEY_ID} )
I am not sure why it would bestuck in a loop. Try adding your updateif() functions to a Concurrent(). If it works it will also improve performance.
Example
Concurrent( UpdateIf( '[dbo].[SQL_TABLE]', TABLE_ID in TableCheckedItems.TABLE_ID, {FOREIGN_KEY_ID: ComboBox27_1.Selected.FOREIGN_KEY_ID} ), UpdateIf( SQL_TABLE_COLLECTION, TABLE_ID in TableCheckedItems.TABLE_ID, {FOREIGN_KEY_ID: ComboBox27_1.Selected.FOREIGN_KEY_ID} ) )
Formula1, Formula2 [, ...] )
@Jeff_Thorpe I'd already tested both updates independently and narrowed it down to the SQL update causing the issue. I tried your solution, and while the collection is updated immediately, the loop is still there.
User | Count |
---|---|
136 | |
128 | |
75 | |
71 | |
70 |
User | Count |
---|---|
209 | |
200 | |
64 | |
63 | |
54 |