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.