Is there some setting I need to change?
We have written procedures to first modify records in a table, and then subsequently delete the modified entries. We decided to do it in two steps out of an abundance of caution, so that the correct entries and only those are removed. This seemed to work smoothly, until we got to a bigger collection of entries. For the particular CliNum there were 165 entries in Agree2. The procedure changed 48 of them and stopped.
Here is the script:
For Agree2 with CliNum = any AgreeDeleteStart CliNum ;
NameLast := "zzz".
Agree2 is the main table, AgreeParties2 is related via CliNum.AgreeDeleteStart is another table related through CliNum, where make just one entry.We run this procedure, another one to delete the changed entries with zzz, and four others on related subforms of Agree2.
I dont understand why this changes 48 entries, then stops.
Is there some global setting that controls this? am unaware of ever making such a setting.I hope someone might have a clue.
Running the procedure again gets the same result. Only after manually deleting the first 48 entries in Agree2 does this procedure go further and then just 48 records, again.