Just tried to patch multiple rows into SQL server. I have set timer to
OnStart
Patch('testeTable', testColumn:"test" & Text(countTimer)); UpdateContext({countTimer: countTimer+1})
OnSelect
UpdateContext({countTimer: 0})
Repeat
counterTimer < 100
However the timer stoped when counterTimer variable exceeded 280 value
I know this worked with collections before
Lesson learned.... Do not use timer to patch straight to SQL. Collect multiple lines with timer to collection and then patch the collection to SQL.
Still wish to know if this is a bug or by design of PA
User | Count |
---|---|
253 | |
106 | |
88 | |
51 | |
43 |