SQL: a Query Language

From OpenOffice.org Wiki

Jump to: navigation, search

This article needs to be checked for accuracy and style.

doc OOo
PAGE_TITLE: U1FMOiBhIFF1ZXJ5IExhbmd1YWdl

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 OpenOffice.org 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.

Image:documentation_note.pngSQL implementation from SDBC is oriented towards the SQL-ANSI-Standard. Microsoft-specific extensions, such as the INNER JOIN construct are not supported. These should be replaced with standard commands (INNER JOIN, for example should be replaced with a corresponding WHERE clause).


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