Devart Forums

Hi,

Probably a stupid question but i want to see the total amount of rows returned for a query the i have run. Currently what is displayed is Record 1 of 302+. I need to see the total amount returned everytime i run a query.
Can someone help please, Thanks.

Hello,

"Record 1 of 302+" means that currently there are 302 records loaded in data editor. The rest of records will be loaded while accessing them. This mode is implemented for preventing data editor from the "Out of memory" error. The mode does not allow accessing all records of a big table at once.
As a workaround for viewing all records, you can set up the page size in Paginal Mode, for example 10000000. Thus, if the number of records in tables does not exceed the preset value, all data will be loaded at once and the number of records will be shown.
To setup Paginal Mode, open the Tools/Options/Data Editor/General menu.

Best Regards.

Thank you JP this worked a charm.