How to execute SQL queries on a DBF file

This topic contains detailed description of running SQL queries on DBF files. There are the core Structured Query Language (SQL) statements:

• SELECT
• CREATE TABLE
• ALTER TABLE
• UPDATE
• INSERT
• DELETE

Besides of common SQL syntax, DBF Commander supports many other Visual FoxPro OLE DB Provider commands, like VAL, STR, CTOD, YEAR, BETWEEN and etc.