SQL > SQL dialog > SQL dialog Builder popup

PdxEditor SQL dialog Builder

Besides looking up the Local SQL manual associated with this application, help building SQL statements is right at hand in the extended popup when right-clicking inside the editor area.
Though extensive, this popup is only a selection of the possibilities using Local SQL.

As the SQL dialog and the Local SQL dialect is used across the Paradox, dBASE and FoxPro data tables also covering the various levels (versions) of each table format, the SQL language uses common keywords for data types across the table formats being translated on the fly into the appropriate field types used by each of the table formats.

SQLbuilder

For a detailed range of SQL keywords, commands and syntax see the Local SQL manual.

See the SQL data type translation.