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.

Select Statement

Create and Drop Table Statements

Insert Statement

Update Statement

Delete Statement

Reserved Keywords