Result size
Greetings,
Currently my query results only show the first 1000 records.
How can I remove this limitation, so I could export ALL result records right to Excel?
-Eugene
Currently my query results only show the first 1000 records.
How can I remove this limitation, so I could export ALL result records right to Excel?
-Eugene
Comments
-
Click the 'Results to Grids' button and re-run your query. The grids don't have any limitation, apart from available memory.
Another option is to use the Util.WriteCsv method in the latest beta to write your results directly to CSV and them load them with Excel:Util.WriteCsv (Customers, @"c:\temp\foo.csv");
-
You can also alter the 1000 record limit in menu option Edit->Preferences, Result tab.