Check Local to determine if a query accesses one or more Paradox or dBASE tables rather than SQL tables. If Local is true, then the query only accesses dBASE or Paradox tables. Otherwise Local is false. Local is set automatically when an application calls the query's Prepare method prior to executing the query. 

Some query component settings, such as Constrained, are only meaningful for queries against Paradox and dBASE tables. Others are only meaningful for queries against remote SQL servers. Local can provide useful information for branching logic in code based on the type of database accessed. It can also be used to determine whether or not the BDE parsed a query using its local query engine rather than passing SQL statements directly to a remote server. 

Constrained 

ExecSQL 

Open 

Prepare