Difference between revisions of "Documentation/BASIC Guide/SQL"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
 
(7 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Documentation/NeedsRework}}
 
 
{{Documentation/BASICGuideTOC/v2
 
{{Documentation/BASICGuideTOC/v2
 
|ShowPrevNext=block
 
|ShowPrevNext=block
 
|ShowPrevPage=block
 
|ShowPrevPage=block
|PrevPage=Documentation/BASIC Guide/Databases
+
|PrevPage=Documentation/BASIC Guide/Database
 
|NextPage=Documentation/BASIC Guide/Database Access Types
 
|NextPage=Documentation/BASIC Guide/Database Access Types
 
|base=block
 
|base=block
}}<!-- {{DISPLAYTITLE:SQL: a Query Language}} -->
+
}}
 
+
{{DISPLAYTITLE:SQL: a Query Language}}
= SQL: a Query Language =
+
 
+
The SQL language is provided as a query language for users of SDBC. To compare the differences between different SQL dialects, the SDBC components from {{AOo}} have their own SQL parser. This uses the query window to check the SQL commands typed and corrects simple syntax errors, such as those associated with uppercase and lowercase characters.
The SQL language is provided as a query language for users of SDBC. To compare the differences between different SQL dialects, the SDBC components from {{OOo}} have their own SQL parser. This uses the query window to check the SQL commands typed and corrects simple syntax errors, such as those associated with uppercase and lowercase characters.
+
  
 
If a driver permits access to a data source that does not support SQL, then it must independently convert the transferred SQL commands to the native access needed.
 
If a driver permits access to a data source that does not support SQL, then it must independently convert the transferred SQL commands to the native access needed.
  
{{Documentation/Note|SQL implementation from SDBC is oriented towards the SQL-ANSI-Standard. Microsoft-specific extensions, such as the <tt>INNER JOIN</tt> construct are not supported. These should be replaced with standard commands (<tt>INNER JOIN</tt>, for example should be replaced with a corresponding <tt>WHERE</tt> clause).}}
+
{{InterWiki Languages BasicGuide|articletitle=Documentation/BASIC Guide/SQL}}
 
+
 
+
 
{{PDL1}}
 
{{PDL1}}

Latest revision as of 15:18, 27 January 2021


The SQL language is provided as a query language for users of SDBC. To compare the differences between different SQL dialects, the SDBC components from Apache OpenOffice have their own SQL parser. This uses the query window to check the SQL commands typed and corrects simple syntax errors, such as those associated with uppercase and lowercase characters.

If a driver permits access to a data source that does not support SQL, then it must independently convert the transferred SQL commands to the native access needed.


Content on this page is licensed under the Public Documentation License (PDL).
Personal tools