Group SQL
DacSession()
Class
Class function of the DacSession class.
DacSqlStatement()
Returns a spezialized SQL statement class object
DacSqlStatement( [<oSession>|<cSession>] ) -> oSqlStatement
DELETE - SQL
Deletes one or more records in a table. END
DELETE FROM <cTableName> [WHERE <lExpression>] [VIA (<coSession>)]
INSERT - SQL
Inserts one or more records into a table.
INSERT INTO <cTableName> [(<cFieldName> [, <cFieldName>, ...])] | VALUES (<Expression> [, <Expression>, ...]) | SELECT <SubSelectExpression> | FROM MEMVAR | FROM ARRAY <aExpression> | FROM OBJECT|NAME <oExpression> [VIA (<coSession>)]
SELECT - SQL
Retrieves data from one or more tables
SELECT [DISTINCT][*|ALL] <ColumnExpression> [AS <cAliasName>] [,...] FROM <SelectSource> [AS <cAliasName>] [,...] [INNER|LEFT [OUTER]|RIGHT [OUTER]|FULL [OUTER]] JOIN <cTableName> ON <JoinExpression> | USING <cFieldName> [, <cFieldName>] ] [WHERE <FilterExpression> | <JoinExpression>] [GROUP BY <Expression> [HAVING <FilterExpression>] [UNION [ALL]|INTERSECT|EXCEPT] <SubSelectExpression>] [ORDER BY <Expression> [ASC|DESC] [, <Expression> [ASC|DESC]]] [LIMIT <nExpression> [OFFSET <nExpression>] [VIA (coSession)] [INTO [CURSOR] <cAlias> |INTO ARRAY <aResult> |INTO OBJECTS <aResult> [CLASS <coClassName>] |EVAL <cbExpression> ] |INTO VALUE <xResult> [INTO TABLE <cResultTableName> [VIA <cResultDbeName>]]
SELECT - SQL FROM Clause
Specifies the tables and join conditions for an SQL SELECT command.
FROM <cTableName> [AS <cAliasName>] | FROM (<Expression>) [AS <cAliasName>] | FROM (<SubSelectExpression>) [AS <cAliasName>] | FROM JoinType JOIN <cTableName> JoinCondition [AS <cAliasName>] JoinType: INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JoinCondition: ON <JoinExpression> | USING <cFieldName> [, <cFieldName>] ]
SELECT - SQL SELECT Clause
Defines the columns in the query result of an SQL SELECT command.
<cFieldName> [AS <cAliasName>] | <cAliasName> -> <cFieldName> [AS <cAliasName>] | (<Expression>) [AS <cAliasName>] | (<SubSelectExpr>) [AS <cAliasName>]
SELECT - SQL UNION Clause
Combines the results of an SQL SELECT command with the results of another SQL SELECT command.
UNION [ALL] |INTERSECT |EXCEPT <SubSelectExpression>
Table()
Determines whether the specified table exists.
Table( <cTablename>[, <oSession>] )
UPDATE - SQL
Updates one or more records in a table. END
UPDATE <cTableName> SET <cFieldName> := <Expression>|<SubSelectExpression> [, ...] | FROM (aData|oData) WHERE <lExpression> [VIA (<coSession>)]