SELECT ALL There are few values that can be applied to the SELECT statement:
WHERE, GROUP BY, ORDER BY and LIMIT. Each value is used only if the correspondent field is filled (white spaces are ignored).
More than one table can be selected using this function. In this case all the results will be displayed on one page
When the SELECT button is clicked the results of executed query is displayed for each selected table. Each table is displayed with its own command bar and column bar.
 |
Using command and column bars the user can customize SELECT query for the each table individually. The customization persists until
the user leaves the Select Results page. By clicking 'Go' button all the select results will be reselected using new settings.
In case of multiple selection, "Exclude" checkbox appears under each command bar. Checking it you will exclude the given table from the displayed result.
If 'select' field on the command bar is left blank, the selected columns of the column bar will be used in SELECT query.
"Print Result" prompt will appear if only one table is selected. The following printing options are available: - Page title appears as the header of the printout.
- Title text style (Bolt, Italic and Underlined). - Title alignment: Left, Right or Center. - Height of the table header and height of the table rows: (min., 20 pixel, 30 pixel).
|