Result size

EugeneGoldberg

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

JoeAlbahari

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");

Tormod

You can also alter the 1000 record limit in menu option Edit->Preferences, Result tab.