Difference between revisions of "SET SQLDIALECT"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(10 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET SQLDIALECT=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Configure SQL statement syntax
 
Configure SQL statement syntax
Line 11: Line 4:
  
 
==Syntax==
 
==Syntax==
SET SQL[DIALECT] TO RECITAL | VFP | MYSQL
+
SET SQLDIALECT TO RECITAL | VFP | MYSQL
 +
 
 +
 
 +
==See Also==
 +
[[SET PAUSE]], [[SET SQL]], [[:Category:SQL|SQL]]
  
  
Line 19: Line 16:
 
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.
  
NOTES:
+
====;====
;
+
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 .
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
+
====.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==
<pre>
+
<code lang="recital">
 
set sqldialect to vfp
 
set sqldialect to vfp
  
 
set sql to mysql
 
set sql to mysql
set sql on</pre>
+
set sql on
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 +
[[Category:Documentation]]
 +
[[Category:Commands]]
 +
[[Category:Set_Commands|SQLDIALECT]]
 +
[[Category:SQL]]
 +
[[Category:SQL Set Commands]]

Latest revision as of 16:07, 5 July 2011

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