Views
Data Access Package API Reference Guide
Product Documentation:
Views Documentation Home
Classes | Enumerations
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
Declarations about SQL tables.

Enumeration Type Documentation

◆ 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.

◆ 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.