Please enable JavaScript to view this site.

ESL Documentation

Navigation: ESL Documentation > ESL DB/Assist

Getting Started with SQL Statements

Scroll Prev Top Next More

In order to use DB/Assist to build the SQL statements that make up your SQL Access Module (SAM), you need to review the following:

How to get started building SQL statements.

Complete information about using the DB/Assist statement construction dialog boxes to build SQL SELECT, UPDATE, DELETE, and INSERT statements. It also describes how to build SQL Data Definition Language (DDL) and Data Control Language (DCL) statements.

How to dynamically run and manage SQL statements after you build them.

The following lists the specific tasks covered in Getting Started with SQL Statements and the topics that you should read for more information about that task.

Get an overview of the steps for building

Steps for Building SQL Statements

Open an existing SQL statement

Opening an Existing SQL Statement

Review the methods for building SQL

Methods for Building SQL Statements

Set options for SQL statements

Setting Statement Options

View the structure of tables in your database

Viewing Your Database