SQL Tab

The SQL tab, located in the Database Connection Setup dialog, allows you to write custom SQL statements to identify tables within a database, as well as query and sort data. When the Use Custom SQL Statement option is enabled, your SQL statement will override any options defined in the Tables, Join, Query, and Sort tabs of the Database Connection Setup dialog.

SQL stands for Structured Query Language and is a language for manipulating databases. The Query, Tables, and Sort tabs work together to automatically generate an SQL statement based on the user's settings. The Use Custom SQL Statement option is intended for use by more advanced users that know how to create their own SQL statements and do not wish to be encumbered by a front-end tool, such as the Query tab.

Although this help topic summarizes the use of BarTender's SQL tab, it is not intended to teach you SQL. SQL is an advanced programming tool used by database programmers. If you do not know what SQL is, use the Query, Tables, and Sort tabs instead. If you decide that you want to learn SQL from scratch, we recommend that you purchase a book on programming with SQL.

Use Custom SQL Statement. Specifies the SQL statement that BarTender will use to process the data source.
Query Prompts. Opens the Query Prompts dialog.

Related Topics

Database Connection Setup Dialog

Open topic with navigation