Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Steve Naidamast: "I just downloaded your new offering of AnySQL Maestro. What a nice product. I was immediately able to connect to an Access database to review the data.

I have already purchased from you your Oracle Maestro as well as your SQLite Maestro.

I am curious as to why you have decided to release such a nice product as Freeware...

Keep up the excellent work".
Scott McWilliams: "I would just like to thank you for making this fantastic tool available for free. I use it all the time for both my professional and personal projects".

More

Add your opinion

AnySQL Maestro online help

Prev Return to chapter overview Next

Data Grid

Below you will find a detailed description of the following data grid options.

 

 

AnySQL Maestro provides you with two grid modes of viewing data:

- Fool grid mode allows you to group, filter and sort data in a usual way.

- Simple mode is provided for working with large records number. For data fetching speed-up, filtering, sorting, and grouping features are not enabled in this mode.

 

You can use notification message to indicate simple mode.

 

Set the number of records to switch to simple mode automatically or select Always use full mode.

 

Limit options

Allows you either to select all records from table after opening the Data tab, or select only specified number of rows on one page with an ability to rotate pages and view all data.

 

Row numbers

This options group allows you to manage grid rows numbering.

To enable/disable the numbering, use Display row numbers checkbox. You can set the number columns width with Maximum digit count. (I.e. for the value '3' the max column number will be 999).

For uniformity you can use the Display leading zeros option. With this option enabled and maximum digit count '3' you numbering column will be of the form: '001, 002, 003, ...'.

 

 Do not open separated connection

With this option enabled a new connections for fetching data is not opened. This gives you an ability to work with data a little bit faster, because time for opening a new connections is not demanded.



Prev Return to chapter overview Next