Solution:

This solution explains how to customize row fetch size values in Microsoft SQL Server installations of Sage Pro ERP.

Important
The following should only be done by a Sage Certified Consultant or Business Partner. Create a full and verified backup before proceeding. This should first be attempted in a test installation and the results should be fully verified before implementing in a live system.

The default settings for the Row Fetch Sizes are All, 100 and 1000. These values can be added and additional options may be added. This customization can only be done on a fully licensed version of Microsoft Visual FoxPro (VFP).

Related Reading
Verify that the correct version of VFP is used for the each version of Sage Pro. For more information on version compatibility, please refer to solution 21336 21336.

To customize this row fetch values, follow the steps below:

1. Open VFP.
2. In the command window, point to the root directory of the Sage Pro SQL installation being modified and type the following query into the command window:DO (_browser) WITH “sm/smfins”

   The Class Browser screen should appear for smfins.vcx.

3. Double-click the smfins form icon.
4. The Class Designer screen appears for form smfins.vcx.
5. Click Ctrl + Shift and click the DataDriller Row Fetch Size drop-down box.
6. In the Properties screen, right-click All and click Non-Default Properties.
7. Click RowSource and edit the values to what is required.
8. Click Save.
9. Exit Visual Fox Pro and launch Sage Pro.
10. Open System Manager.
11. Under the Maintain menu, point-to Setup and click System Installation.
12. Click Edit.
13. Open the Row Fetch Size drop-down box and observe that the values have been correctly edited.
14. Select the appropriate value and save.
15. Test using various datadrillers and picklists to verify that this selection functions correctly.

© Copyright Sage Software