11	SQL Statements for Flat-File Drivers

This chapter describes the SQL statements that you can use with the flat-file drivers (Btrieve, dBASE, and Text). Any exceptions to the supported SQL functionality described in this chapter are documented in the individual flat-file driver chapters in the DataDirect Connect Series for ODBC User’s Guide.

The database drivers parse SQL statements and translate them into a form that the database can understand. The SQL statements described in this chapter let you:

■	Read, insert, update, and delete rows from a database

■	Create new tables

■	Drop existing tables

These SQL statements allow your application to be portable across other databases. This chapter includes information about the following topics:

■	“Select Statement”

■	“Create and Drop Table Statements”

■	“Insert Statement”

■	“Update Statement”

■	“Delete Statement”

■	“Reserved Keywords”