Difference between revisions of "SET SQLDIALECT"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
SQL Applications | SQL Applications | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[SET SQL]] | + | [[SET SQL]], [[:Category:SQL|SQL]] |
| Line 23: | Line 20: | ||
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. | 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 RECITAL or MYSQL. It is used as a line continuation character when SQLDIALECT is set to VFP. | The semi-colon, ’;’, is used to terminate SQL statements when SQLDIALECT is set to RECITAL or MYSQL. It is used as a line continuation character when SQLDIALECT is set to VFP. | ||
| − | EXEC SQL | + | ====EXEC SQL==== |
When SQLDIALECT is set to RECITAL, SQL statements embedded in programs must be preceded by the EXEC SQL statement unless SET SQL is ON. | When SQLDIALECT is set to RECITAL, SQL statements embedded in programs must be preceded by the EXEC SQL statement unless SET SQL is ON. | ||
| − | .sql programs | + | ====.sql programs==== |
When a program with a ’.sql’ file extension is run, SQLDIALECT is automatically set to MYSQL and SET SQL is set ON. | When a program with a ’.sql’ file extension is run, SQLDIALECT is automatically set to MYSQL and SET SQL is set ON. | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
set sqldialect to vfp | set sqldialect to vfp | ||
set sql to mysql | set sql to mysql | ||
| − | set sql on</ | + | set sql on |
| + | </code> | ||
Revision as of 11:34, 20 April 2009
Contents
Class
SQL Applications
Purpose
Configure SQL statement syntax
Syntax
SET SQLDIALECT TO RECITAL | VFP | MYSQL
See Also
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 RECITAL or MYSQL. It is used as a line continuation character when SQLDIALECT is set to VFP.
EXEC SQL
When SQLDIALECT is set to RECITAL, SQL statements embedded in programs must be preceded by the EXEC SQL statement unless SET SQL is ON.
.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 Database Server, Recital Mirage Server, Recital Terminal Developer
