SQL queries

The common query engine uses a convenient subset of SQL to access dBASE, FoxPro, Access, and Paradox tables. This subset can also be used to join server-based SQL tables with these tables. The appropriate BDE driver must be installed to allow server-based SQL access.

To exploit the full functionality of the server, you can use your server's dialect of SQL. Use passthrough SQL to send native SQL statements directly to your database server to be executed there. Queries executed in the native dialect might not result in updateable cursors. If the appropriate BDE driver is installed, the BDE query interface functions can also be used to pass SQL statements to the server for processing, in the native dialect of a server-based system, such as Oracle or Sybase.