What To Do If Your SQL Query Results Are Limited to 10,000 Records
That limit is the default in GoldMine; however, we can quickly change that!
First, locate your <<username.ini>> file where your GoldMine is installed. Here, I’ll go to the “K” drive then GoldMine and find chad.ini, i.e. k:\goldmine\chad.ini.
Open that file using Notepad. Normally double-clicking on the document will automatically open it using Notepad. Then, find the [GoldMine] Section.
Add the entry:
SQLQueryLimit=100000 … Change the 100,000 to whatever the maximum number of records you want returned.

... and to my readers in Canada & The United States... Happy Canada Day & Independence Day!









