SQL Builder
Jump to navigation
Jump to search
The SQL builder only creates SQL SELECT statements.
These records can be used to create Tables used in Reports.
The SQL Builder can also be accessed via the SQL button next to any nuBuilder Forte Textarea Object requiring SQL.
Creating an SELECT Statement
Description
Description of SQL
Field and Relationships
This is a graphical way to create table relationships.
You can add a table by making a selection from Add Table above the graphical area.
Each table can be dragged by clicking on the table name.
Each table added has..
- A Tablename.
- A field that will allow you to enter an alias for this table.
- A list of fields belonging to this table.
- A Checkbox at the left of each field name allowing that field to by chosen.
- A Checkbox at the top left allowing all fields to by chosen at once.
To create a relationship between 2 tables you need to do 2 things.
- Click a the first field when its name becomes red.
- Unclick as you hover over a field on another table when its name becomes green.