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 |
|
Open an existing SQL statement |
|
Review the methods for building SQL |
|
Set options for SQL statements |
|
View the structure of tables in your database |