The table data are shown on the Data page of the Table window, and the SQL query are shown on the Result page of SQL window (or below the query text depending on the environment options).
While working with Table window is more intuitive, it is recommended to use SQL queries instead of Table windows whenever possible, because the explicit database queries often require less memory, less database load etc.
Working with table or SQL query data is very similar. For example, it is possible to export, print, view in different modes, copy them etc. There are also differences: for example, importing, packing, emptying operations are defined for tables only, not for queries. There are some differences in sorting table and query data.
Some data operations are enabled only for data sets, opened using certain interface. Also, some operations can work differently depending on the interface used to connect the database.
It is possible to perform some operations with group of records (for example, deleting, exporting, etc.). To select group of records, turn on multiple selection by using the corresponding button, then select records by the following available combinations: SHIFT+<arrows>, CTRL+<mouse>, SHIFT+PgDown, SHIFT+PgUp, SHIFT+HOME, SHIFT+END.
To edit BLOB fields fields (MEMO, CLOB, graphic etc.), choose the corresponding item from Tools menu. There are also specific functions to work with numeric or string data there.
There are many special functions to work with current record (Row menu) or current field / column (Column menu). Many of these functions and some other ones are available also in the context menu of data grids.
You can customize the data view using many options.
See also
