Multirecord update page size

With the Page size for Multi-Record Update preference, you can perform a multirecord update on result sets that are greater than 100 records, provided that the site maximum is greater than 100.

Multirecord update only affects the records that are shown on the current result set page. The number of records that you choose to run multirecord update on is determined by these values:
  • The value of the Number of rows in one page preference
  • The value of the Page size for Multi-Record Update preference
You set these preferences in the User Preferences dialog box.
When you begin a multirecord update, one of these scenarios occurs:
  • If the number of records in your result set is less than or equal to the Number of rows in one page value and less than or equal to the Page size for Multi-Record Update value, the Multi-Record Update tab opens.

    For example, suppose the Number of rows in one page value is 20 and the Page size for Multi-Record Update value is 20. You run a query that returns a result set with 5 records. Five records are fewer than the 20 records that are specified in the Number of rows in one page and the Page size for Multi-Record Update preferences. Therefore, the Multi-Record Update tab opens.

  • If the number of records that are displayed on the result set page is less than the Page size for Multi-Record Update value and there are records in the result set that are not currently displayed, then the Increase Page Size dialog box opens. You can rerun the query to include more records in the result set, though the query results might change. You can continue with the multirecord update with the records in the current result set. Or, you can cancel the multirecord update.

    For example, suppose the Number of rows in one page value is 20 and the Page size for Multi-Record Update value is 30. You run a query that returns a result set with 22 records. The result set displays 20 of the 22 records because the Number of rows in one page value is 20. The Increase Page Size dialog box opens. Because the Page size for Multi-Record Update value allows up to 30 records to be displayed, you can rerun the query to include up to 30 records. You can cancel the multirecord update. Or, you can continue the multirecord update with the 20 records that are currently in the result set.

  • If the number of records that are displayed on the result set page is greater than the Page size for Multi-Record Update value, then the Decrease Page Size dialog box opens. You can run the query again to decrease the number of records in the multirecord update result set, although the query results might change. Or, you can cancel the multirecord update.

    For example, suppose the Number of rows in one page value is 50 and the Page size for Multi-Record Update value is 30. You run a query that returns a result set with 46 records and they are all currently shown on the page. The Decrease Page Size dialog box opens. The result set of 46 records is larger than 30, the number of records that multirecord update can operate on. You can rerun the query to display only 30 records on which to run the multi-record update, or you can cancel the multirecord update.