- Home
- About
- Testimonials
- Demos
- Download
- Documentation
- Blogs
- Forum
- Support

Packages:
System.IO
default
System.Web.UI
System.Web.UI.ActiveControls
System.Web.UI.WebControls
System.Web.UI.WebControls.assets
System.Web
System.Web.Services
System.Xml
System.Data.Common.Pgsql
System.Data.Common.Mssql
System.Data.Common
System.Data.Common.Mysql
System.Data.Commom.Sqlite
System.Data.Common.Oracle
System.Data.Common.Sqlite
System.Data
System.Data.ActiveRecord
System.Data.ActiveRecord.Relations
System.Data.ActiveReecord.Scaffold.InputBuilder
System.Data.ActiveRecord.Scaffold
System.Data.DataGateway
System.Data.SqlMap
System.Data.SqlMap.Statements
System.Data.SqlMap.Configuration
System.I18N
System.Util
System
System.Collections
System.Caching
System.Security
System.Exceptions
Classes:
TDbCommandBuilder
TDbMetaData
TDbTableColumn
TDbTableInfo
TMssqlCommandBuilder
TMysqlCommandBuilder
TOracleCommandBuilder
TOracleTableInfo
TPgsqlCommandBuilder
TSqliteCommandBuilder

Keyword

# Element index for package System.Data.Common

[ a ] [ b ] [ c ] [ f ] [ g ] [ h ] [ i ] [ j ] [ n ] [ r ] [ s ] [ t ] [ _ ]

## _

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

top

## a

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

top

## b

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

top

## c

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

top

## f

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

top

## g

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

top

## h

hasIntegerKey
  in file TDbCommandBuilder.php, method TDbCommandBuilder::hasIntegerKey()
hasSequence
  in file TDbTableColumn.php, method TDbTableColumn::hasSequence()

top

## i

isSearchableColumn
  in file TPgsqlCommandBuilder.php, method TPgsqlCommandBuilder::isSearchableColumn()
isSearchableColumn
  in file TOracleCommandBuilder.php, method TOracleCommandBuilder::isSearchableColumn()

top

## j

joinOrdering
  in file TMssqlCommandBuilder.php, method TMssqlCommandBuilder::joinOrdering()

top

## n

UNDEFINED_VALUE
  in file TDbTableColumn.php, class constant TDbTableColumn::UNDEFINED_VALUE

top

## r

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

top

## s

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

top

## t

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

top