## [System.Data.Common] element index

### Package indexes

- System.Caching
- System.Collections
- System.Data.ActiveRecord
- System.Data.ActiveRecord.Relations
- System.Data.ActiveReecord.Scaffold.InputBuilder
- System.Data.ActiveRecord.Scaffold
- System.Data.Common.Pgsql
- System.Data.Common.Mssql
- System.Data.Common.Mysql
- System.Data.Commom.Sqlite
- System.Data.Common.Oracle
- System.Data.Common.Sqlite
- System.Data.DataGateway
- System.Data.SqlMap.Configuration
- System.Data.SqlMap.Statements
- System.Data.SqlMap
- System.Data
- System.Exceptions
- System.I18N
- System
- System.IO
- System.Security
- System.Util
- System.Web.Services
- System.Web
- System.Web.UI.ActiveControls
- System.Web.UI.WebControls
- System.Web.UI
- System.Web.UI.WebControls.assets
- System.Xml

All elements
_
top

__construct
  TOracleTableInfo::__construct() in TOracleTableInfo.php
  Sets the database table meta data information.
__construct
  TDbTableInfo::__construct() in TDbTableInfo.php
  Sets the database table meta data information.
__construct
  TDbTableColumn::__construct() in TDbTableColumn.php
  Sets the table column meta data.
__construct
  TDbMetaData::__construct() in TDbMetaData.php
__construct
  TDbCommandBuilder::__construct() in TDbCommandBuilder.php

a
top

applyCriterias
  TDbCommandBuilder::applyCriterias() in TDbCommandBuilder.php
applyLimitOffset
  TOracleCommandBuilder::applyLimitOffset() in TOracleCommandBuilder.php
  Overrides parent implementation to use Oracle way of get paginated RecordSet instead of using LIMIT sql clause.
applyLimitOffset
  TMssqlCommandBuilder::applyLimitOffset() in TMssqlCommandBuilder.php
  Overrides parent implementation. Alters the sql to apply $limit and $offset.
applyLimitOffset
  TSqliteCommandBuilder::applyLimitOffset() in TSqliteCommandBuilder.php
  Alters the sql to apply $limit and $offset.
applyLimitOffset
  TDbCommandBuilder::applyLimitOffset() in TDbCommandBuilder.php
  Alters the sql to apply $limit and $offset. Default implementation is applicable for PostgreSQL, MySQL and SQLite.
applyOrdering
  TDbCommandBuilder::applyOrdering() in TDbCommandBuilder.php

b
top

bindArrayValues
  TDbCommandBuilder::bindArrayValues() in TDbCommandBuilder.php
bindColumnValues
  TDbCommandBuilder::bindColumnValues() in TDbCommandBuilder.php
  Bind the name-value pairs of $values where the array keys correspond to column names.

c
top

createCommand
  TDbCommandBuilder::createCommand() in TDbCommandBuilder.php
createCommandBuilder
  TDbTableInfo::createCommandBuilder() in TDbTableInfo.php
createCommandBuilder
  TDbMetaData::createCommandBuilder() in TDbMetaData.php
  Creates a command builder for a given table name.
createCommandBuilder
  TOracleTableInfo::createCommandBuilder() in TOracleTableInfo.php
createCountCommand
  TDbCommandBuilder::createCountCommand() in TDbCommandBuilder.php
  Creates a count(*) command for the table described in setTableInfo.
createDeleteCommand
  TDbCommandBuilder::createDeleteCommand() in TDbCommandBuilder.php
  Creates a delete command for the table described in setTableInfo.
createFindCommand
  TDbCommandBuilder::createFindCommand() in TDbCommandBuilder.php
  Appends the $where condition to the string "SELECT * FROM tableName WHERE ".
createInsertCommand
  TDbCommandBuilder::createInsertCommand() in TDbCommandBuilder.php
  Creates an insert command for the table described in setTableInfo for the given data.
createTableInfo
  TDbMetaData::createTableInfo() in TDbMetaData.php
  This method should be implemented by decendent classes.
createUpdateCommand
  TDbCommandBuilder::createUpdateCommand() in TDbCommandBuilder.php
  Creates an update command for the table described in setTableInfo for the given data.

f
top

findOrdering
  TMssqlCommandBuilder::findOrdering() in TMssqlCommandBuilder.php
  Base on simplified syntax http://msdn2.microsoft.com/en-us/library/aa259187(SQL.80).aspx

g
top

getAllowNull
  TDbTableColumn::getAllowNull() in TDbTableColumn.php
getColumn
  TOracleTableInfo::getColumn() in TOracleTableInfo.php
getColumn
  TDbTableInfo::getColumn() in TDbTableInfo.php
getColumnBindings
  TDbCommandBuilder::getColumnBindings() in TDbCommandBuilder.php
  Create a name-value or position-value if $position=true binding strings.
getColumnId
  TDbTableColumn::getColumnId() in TDbTableColumn.php
getColumnIndex
  TDbTableColumn::getColumnIndex() in TDbTableColumn.php
getColumnName
  TDbTableColumn::getColumnName() in TDbTableColumn.php
getColumnNames
  TDbTableInfo::getColumnNames() in TDbTableInfo.php
getColumnNames
  TOracleTableInfo::getColumnNames() in TOracleTableInfo.php
getColumns
  TOracleTableInfo::getColumns() in TOracleTableInfo.php
getColumns
  TDbTableInfo::getColumns() in TDbTableInfo.php
getColumnSize
  TDbTableColumn::getColumnSize() in TDbTableColumn.php
getDbConnection
  TDbMetaData::getDbConnection() in TDbMetaData.php
getDbConnection
  TDbCommandBuilder::getDbConnection() in TDbCommandBuilder.php
getDbType
  TDbTableColumn::getDbType() in TDbTableColumn.php
getDefaultValue
  TDbTableColumn::getDefaultValue() in TDbTableColumn.php
getForeignKeys
  TOracleTableInfo::getForeignKeys() in TOracleTableInfo.php
getForeignKeys
  TDbTableInfo::getForeignKeys() in TDbTableInfo.php
getInfo
  TOracleTableInfo::getInfo() in TOracleTableInfo.php
getInfo
  TDbTableInfo::getInfo() in TDbTableInfo.php
getInfo
  TDbTableColumn::getInfo() in TDbTableColumn.php
getInsertFieldBindings
  TDbCommandBuilder::getInsertFieldBindings() in TDbCommandBuilder.php
  Returns a list of insert field name and a list of binding names.
getInstance
  TDbMetaData::getInstance() in TDbMetaData.php
  Obtain database specific TDbMetaData class using the driver name of the database connection.
getIsExcluded
  TDbTableColumn::getIsExcluded() in TDbTableColumn.php
getIsForeignKey
  TDbTableColumn::getIsForeignKey() in TDbTableColumn.php
getIsPrimaryKey
  TDbTableColumn::getIsPrimaryKey() in TDbTableColumn.php
getIsView
  TOracleTableInfo::getIsView() in TOracleTableInfo.php
getIsView
  TDbTableInfo::getIsView() in TDbTableInfo.php
getLastInsertID
  TDbCommandBuilder::getLastInsertID() in TDbCommandBuilder.php
  Iterate through all the columns and returns the last insert id of the first column that has a sequence or serial.
getLastInsertID
  TMssqlCommandBuilder::getLastInsertID() in TMssqlCommandBuilder.php
  Overrides parent implementation. Uses "SELECT @@Identity".
getLowerCaseColumnNames
  TDbTableInfo::getLowerCaseColumnNames() in TDbTableInfo.php
getLowerCaseColumnNames
  TOracleTableInfo::getLowerCaseColumnNames() in TOracleTableInfo.php
getMaxiumNumericConstraint
  TDbTableColumn::getMaxiumNumericConstraint() in TDbTableColumn.php
getNumericPrecision
  TDbTableColumn::getNumericPrecision() in TDbTableColumn.php
getNumericScale
  TDbTableColumn::getNumericScale() in TDbTableColumn.php
getPdoType
  TDbTableColumn::getPdoType() in TDbTableColumn.php
getPdoType
  TDbCommandBuilder::getPdoType() in TDbCommandBuilder.php
getPHPType
  TDbTableColumn::getPHPType() in TDbTableColumn.php
  Returns the derived PHP primitive type from the db type. Default returns 'string'.
getPrimaryKeys
  TOracleTableInfo::getPrimaryKeys() in TOracleTableInfo.php
getPrimaryKeys
  TDbTableInfo::getPrimaryKeys() in TDbTableInfo.php
getSearchCondition
  TDbCommandBuilder::getSearchCondition() in TDbCommandBuilder.php
getSearchCondition
  TPgsqlCommandBuilder::getSearchCondition() in TPgsqlCommandBuilder.php
  Overrides parent implementation to use PostgreSQL's ILIKE instead of LIKE (case-sensitive).
getSearchExpression
  TDbCommandBuilder::getSearchExpression() in TDbCommandBuilder.php
  Computes the SQL condition for search a set of column using regular expression (or LIKE, depending on database implementation) to match a string of keywords (default matches all keywords).
getSearchExpression
  TPgsqlCommandBuilder::getSearchExpression() in TPgsqlCommandBuilder.php
  Overrides parent implementation. Only column of type text or character (and its variants) accepts the LIKE criteria.
getSearchExpression
  TOracleCommandBuilder::getSearchExpression() in TOracleCommandBuilder.php
  Overrides parent implementation. Only column of type text or character (and its variants) accepts the LIKE criteria.
getSequenceName
  TDbTableColumn::getSequenceName() in TDbTableColumn.php
getTableFullName
  TDbTableInfo::getTableFullName() in TDbTableInfo.php
getTableFullName
  TOracleTableInfo::getTableFullName() in TOracleTableInfo.php
getTableInfo
  TDbCommandBuilder::getTableInfo() in TDbCommandBuilder.php
getTableInfo
  TDbMetaData::getTableInfo() in TDbMetaData.php
  Obtains table meta data information for the current connection and given table name.
getTableInfoClass
  TDbMetaData::getTableInfoClass() in TDbMetaData.php
getTableName
  TDbTableInfo::getTableName() in TDbTableInfo.php
getTableName
  TOracleTableInfo::getTableName() in TOracleTableInfo.php

h
top

hasIntegerKey
  TDbCommandBuilder::hasIntegerKey() in TDbCommandBuilder.php
hasSequence
  TDbTableColumn::hasSequence() in TDbTableColumn.php

i
top

isSearchableColumn
  TPgsqlCommandBuilder::isSearchableColumn() in TPgsqlCommandBuilder.php
isSearchableColumn
  TOracleCommandBuilder::isSearchableColumn() in TOracleCommandBuilder.php

j
top

joinOrdering
  TMssqlCommandBuilder::joinOrdering() in TMssqlCommandBuilder.php

n
top

UNDEFINED_VALUE
  TDbTableColumn::UNDEFINED_VALUE in TDbTableColumn.php

r
top

reverseDirection
  TMssqlCommandBuilder::reverseDirection() in TMssqlCommandBuilder.php
rewriteLimitOffsetSql
  TMssqlCommandBuilder::rewriteLimitOffsetSql() in TMssqlCommandBuilder.php
  Rewrite sql to apply $limit > and $offset > 0 for MSSQL database.

s
top

setDbConnection
  TDbCommandBuilder::setDbConnection() in TDbCommandBuilder.php
setInfo
  TOracleTableInfo::setInfo() in TOracleTableInfo.php
setInfo
  TDbTableInfo::setInfo() in TDbTableInfo.php
setInfo
  TDbTableColumn::setInfo() in TDbTableColumn.php
setTableInfo
  TDbCommandBuilder::setTableInfo() in TDbCommandBuilder.php

t
top

TMssqlCommandBuilder.php
  TMssqlCommandBuilder.php in TMssqlCommandBuilder.php
TMysqlCommandBuilder.php
  TMysqlCommandBuilder.php in TMysqlCommandBuilder.php
TOracleCommandBuilder.php
  TOracleCommandBuilder.php in TOracleCommandBuilder.php
TOracleTableInfo.php
  TOracleTableInfo.php in TOracleTableInfo.php
TPgsqlCommandBuilder.php
  TPgsqlCommandBuilder.php in TPgsqlCommandBuilder.php
TSqliteCommandBuilder.php
  TSqliteCommandBuilder.php in TSqliteCommandBuilder.php
TDbCommandBuilder.php
  TDbCommandBuilder.php in TDbCommandBuilder.php
TDbMetaData.php
  TDbMetaData.php in TDbMetaData.php
TDbTableColumn.php
  TDbTableColumn.php in TDbTableColumn.php
TDbTableInfo.php
  TDbTableInfo.php in TDbTableInfo.php
TDbCommandBuilder
  TDbCommandBuilder in TDbCommandBuilder.php
  TDbCommandBuilder provides basic methods to create query commands for tables giving by setTableInfo the property.
TDbMetaData
  TDbMetaData in TDbMetaData.php
  TDbMetaData is the base class for retrieving metadata information, such as table and columns information, from a database connection.
TDbTableColumn
  TDbTableColumn in TDbTableColumn.php
  TDbTableColumn class describes the column meta data of the schema for a database table.
TDbTableInfo
  TDbTableInfo in TDbTableInfo.php
  TDbTableInfo class describes the meta data of a database table.
TMssqlCommandBuilder
  TMssqlCommandBuilder in TMssqlCommandBuilder.php
  TMssqlCommandBuilder provides specifics methods to create limit/offset query commands for MSSQL servers.
TMysqlCommandBuilder
  TMysqlCommandBuilder in TMysqlCommandBuilder.php
  TMysqlCommandBuilder implements default TDbCommandBuilder
TOracleCommandBuilder
  TOracleCommandBuilder in TOracleCommandBuilder.php
  TOracleCommandBuilder provides specifics methods to create limit/offset query commands for Oracle database.
TOracleTableInfo
  TOracleTableInfo in TOracleTableInfo.php
  TDbTableInfo class describes the meta data of a database table.
TPgsqlCommandBuilder
  TPgsqlCommandBuilder in TPgsqlCommandBuilder.php
  TPgsqlCommandBuilder provides specifics methods to create limit/offset query commands for Pgsql database.
TSqliteCommandBuilder
  TSqliteCommandBuilder in TSqliteCommandBuilder.php
  TSqliteCommandBuilder provides specifics methods to create limit/offset query commands for Sqlite database.