How can return all rows in sql execution by default?

[angelg]

Hi!
When I execute a query as a select, in the grid just show only a few records (20), and for get all records you have to clic last page button (ALT+END).
How can I directlly obtain all records by default in the grid?
Thanks in advance

 

[patch]

In [Preferences-SQL Window] there is an option [Records per Page] where you can select how many rows are retrieved.
I think you will return to a smalller set pretty soon, though. Fetching all the rows takes up time. I you want to see the latest rows you might be better of using an order by in your query.

 

[angelg]

Thank's a lot

 

[angelg]

Yes, just for tables with no large amount of records

 

[Starina]

From manual

You can use special directives in a comment before each SQL statement to control aspects of the query. For example:
-- Records=[All | Page | ]
Records directive controls the number of initially fetched records. Specify All to fetch all records, Page to fetch one page of records (depends on the window height), or the exact number of records.