When running sql queries in the GoldMine SQL query window by default it will only show the first 10000 records of the results.

This can be expanded by adding the following line into the [goldmine] section of the gm.ini file.

Sqlquerylimit=xxxxxx

Where xxxxxx is the number of records you wish to display.

NB: the gm.ini file is stored within the GoldMine application folder and should be modifed in a plain text editor like notepad.