SaaS: Query Builder: SQL Design

This page is external content designed to help familiarize you with the SaaS. It is not the live SaaS. Register for a Free Test Account to use the Real SaaS.

your_account

This a very simple Query that could easily have been done in the Simple Editor. Only 1 Table. Many Tables could be JOINED in this area.
More complex examples & a Movie coming soon.

click Tables, View, Functions (set returning)

will appear here (see left). Then drag lines between them for your JOINS.

The functionality, current mode (single record or linear), navigation bar, displayed fields, tab order and appearance of this form are controlled by the GYRE. Contact your Administrator if you do not have GYRE privileges or require assistance.

To Edit a Record:

A selected record will have a Grey background.
Place your cursor into a datafield and type.
Use Tab (keyboard) to move to the next datafield.
Press Enter (keyboard) to commit your data. Your background will flicker Green.

To Create (or Delete) a Record:

If your GYRE has been enabled for the Toolbar, you will be able to Create New - or Delete existing records. An 'empty' (no values), temporary record will be at the bottom of your page when your page loads. This 'empty record' is only in your browser - and is not in your target Table. Note - you may need to scroll down for this record to be visible in your browser.
An Empty record will show (examples) 8 of 7 ... 49 of 48, etc in the Toolbar.
Type into your datafields in the EMPTY record, using Tab to move your cursor to the next field. When you are done - hit Enter on your keyboard. This record will flicker Green - and your new record will be committed to your Table.
After you hit Enter - a new 'Empty record' will appear at the bottom of your Browser. Continue the process described above until you are finished.

Note: If you require additional assistance or navigation tools, contact your Administrator.