- 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