SET SQLDIALECT

Purpose

Configure SQL statement syntax

Syntax

SET SQLDIALECT TO RECITAL | VFP | MYSQL

See Also

SET PAUSE, SET SQL, SQL

Description

Where Recital, MySQL and VFP differ in their SQL syntax, the SET SQLDIALECT command can be used to select the syntax to be used.

By default, SET SQLDIALECT is set to RECITAL. Since the SET SQLDIALECT setting affects program compilation, it should be set prior to compilation rather than in a program itself, for example in a config.db configuration file.

;

The semi-colon, ’;’, is used to terminate SQL statements when SQLDIALECT is set to MYSQL. It is used as a line continuation character when SQLDIALECT is set to VFP or RECITAL .

.sql programs

When a program with a ’.sql’ file extension is run, SQLDIALECT is automatically set to MYSQL and SET SQL is set ON.

Example

set sqldialect to vfp
 
set sql to mysql
set sql on

Products

Recital Server, Recital