sqltable.h File Reference

#include <ilviews/dataccess/memtable.h>
#include <ilviews/dataccess/dbms/session.h>
#include <ilviews/dataccess/tblref.h>
#include <ilviews/dataccess/intset.h>
#include <ilviews/dataccess/tbldef.h>
#include <ilviews/dataccess/sqltblex.h>
#include <ilviews/dataccess/intrface/sqltbitf.h>

Classes
class	IliSQLTable
	Table class. More...

Enumerations
enum	IliSQLJoinType { IliInnerJoin, IliLeftOuterJoin, IliRightOuterJoin }
	This enumerated type defines the different types that a join can have in an IliSQLTable object. In the following description, two tables are joined. One is designated as the left table and the other is designated as the right table. The left table is the first one that occurs in the call to IliSQLTable::addJoin. More...
enum	IliSQLOperation {   IliSQLScalar, IliSQLGroupBy, IliSQLCount, IliSQLSum,   IliSQLAvg, IliSQLMin, IliSQLMax }
	This enumerated type defines the different types of operations that can be applied to a column in an SQL query. More...

Detailed Description

[library dbaccess ilviews/dataccess/sqltable.h] Declarations about SQL tables.

Enumeration Type Documentation

enum IliSQLJoinType

This enumerated type defines the different types that a join can have in an IliSQLTable object. In the following description, two tables are joined. One is designated as the left table and the other is designated as the right table. The left table is the first one that occurs in the call to IliSQLTable::addJoin.

Enumerator
IliInnerJoin	The join is an inner join. This means that only rows that match the join condition in both tables will produce a row in the result.
IliLeftOuterJoin	The join is a left outer join. This means that each row in the left table will produce a row in the result. However, only those rows in the right table that match the join condition will produce a row in the result.
IliRightOuterJoin	The join is a right outer join. This means that each row in the right table will produce a row in the result. However, only those rows in the left table that match the join condition will produce a row in the result.

enum IliSQLOperation

This enumerated type defines the different types of operations that can be applied to a column in an SQL query.

Enumerator
IliSQLScalar	The column is left unchanged.
IliSQLGroupBy	All rows in the result set are grouped according to the column.
IliSQLCount	The value of the column is the row count in the result set.
IliSQLSum	The value of the column is the sum of the values in the original column.
IliSQLAvg	The value of the column is the average of the values in the original column.
IliSQLMin	The value of the column is the least value in the original column.
IliSQLMax	The value of the column is the greatest value in the original column.