SQL Builder: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
The SQL builder only creates SQL SELECT | The SQL builder only creates SQL SELECT statements. | ||
These records can be used to create [[Reports#Table|Tables]] used in [[Reports]]. | |||
The SQL Builder can also be | 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''' | |||
Each table added has.. | |||
*A Tablename. | |||
*A field where the user can enter an alias for this table. | |||
*A list of fields belonging to this table | |||
*A Checkbox at the left of each field name allowing this field to by chosen. | |||
*A Checkbox at the top left allowing all fields to by chosen at once. | |||
==Clauses== | |||
Revision as of 22:04, 8 July 2017
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
Each table added has..
- A Tablename.
- A field where the user can enter an alias for this table.
- A list of fields belonging to this table
- A Checkbox at the left of each field name allowing this field to by chosen.
- A Checkbox at the top left allowing all fields to by chosen at once.