Telerik OpenAccess Classic

Telerik OpenAccess ORM Send comments on this topic.
SELECT Statement Syntax Summary
See Also
Programmer's Guide > OpenAccess ORM Classic (Old API) > Telerik OpenAccess ORM OQL Reference > OQL - Object Query Language > The Select Statement > SELECT Statement Syntax Summary

Glossary Item Box

This documentation article is a legacy resource describing the functionality of the deprecated OpenAccess Classic only. The contemporary documentation of Telerik OpenAccess ORM is available here.

Following is a syntax summary for the SELECT statement. The syntax described is a subset of the ODMG specification and represents the OpenAccess OQL implementation. In this and following syntax declarations, OQL keywords and commands are displayed as COMMAND, parameters are displayed as parameter, optional elements are displayed as optional-element, and literal values are displayed as literal. Where one of a collection of values may be used, the collection is enclosed in braces ({}) with the values separated by or-bars (|). Only one of the values is to be used in the expression. SELECT result-set FROM set-definition, set-definition WHERE expression ORDER BY member-list The following are syntax summaries for the various parameters describing the statement clauses:

  • result-set: { * | set-variable | path-expression } (For more information, see Result Sets)
  • set-definition: { set AS set-variable | set-variable IN set }
  • set: { extent | embedded-set | result-set-id }
  • expression: compare-predicate { AND | OR } compare-predicatecompare-predicate: path-expressioncomparison-operator { literal | COUNT-statement operator number | EXISTS-statement = { true | false } }
  • path-expression: set-variable dot additional indirections member-name (For more information, see Path Expressions)
    dot: { . | -> }
  • literal: literal OpenAccess basetype (string, int, etc.)
  • comparison-operator: { = | == | != | <> | > | < | >= | <= } LIKE | NOT LIKE
  • member-list: path-expression { ASC | DESC }, path expression { ASC | DESC }
  • Aggregate functions

See Also