Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I change the amount of records I receive from a SQL Query?

Status
Not open for further replies.

SkyScrpr

Technical User
Aug 1, 2008
1
0
0
Currently, if I do an SQL query I have a limit of 10,000 records that could be displayed for such a query.

Previous posts said I could modify the ini files, how do I do that?
 
Log out of GoldMine.
Open your user.ini file.
In the [GOLDMINE] section, add:

SQLQueryLimit=25000

Where 25000 = the record limit you want.
Save and close the file.
Log back into GoldMine and run your query.




__________
It's better to have loved and lost than live with the idiot for the rest of your life.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top