- 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:
IMappedStatement
TCachingStatement
TDeleteMappedStatement
TInsertMappedStatement
TMappedStatement
TPostSelectBinding
TPreparedCommand
TPreparedStatement
TPreparedStatementFactory
TResultSetListItemParameter
TResultSetMapItemParameter
TSelectMappedStatement
TSimpleDynamicSql
TSqlMapObjectCollectionTree
TSqlMapSelect
TStaticSql
TUpdateMappedStatement

Keyword

# Element index for package System.Data.SqlMap.Statements

[ a ] [ b ] [ c ] [ e ] [ f ] [ g ] [ h ] [ i ] [ o ] [ p ] [ r ] [ s ] [ t ] [ u ] [ _ ]

## _

__construct
  in file TPreparedStatementFactory.php, method TPreparedStatementFactory::__construct()
__construct
  in file TSimpleDynamicSql.php, method TSimpleDynamicSql::__construct()
__construct
  in file TPreparedStatement.php, method TPreparedStatement::__construct()
__construct
  in file TMappedStatement.php, method TResultSetMapItemParameter::__construct()
__construct
  in file TMappedStatement.php, method TMappedStatement::__construct()
  Creates a new mapped statement.
__construct
  in file TMappedStatement.php, method TResultSetListItemParameter::__construct()
__construct
  in file TCachingStatement.php, method TCachingStatement::__construct()

top

## a

add
  in file TMappedStatement.php, method TSqlMapObjectCollectionTree::add()
  Add a new node to the object tree graph.
addNode
  in file TMappedStatement.php, method TSqlMapObjectCollectionTree::addNode()
  Find the parent node and add the new node as its child.
addResultMapGroupBy
  in file TMappedStatement.php, method TMappedStatement::addResultMapGroupBy()
  ResultMap with GroupBy property. Save object collection graph in a tree and collect the result later.
applyParameterMap
  in file TPreparedCommand.php, method TPreparedCommand::applyParameterMap()
applyResultMap
  in file TMappedStatement.php, method TMappedStatement::applyResultMap()
  Apply result mapping.

top

## b

buildPreparedStatement
  in file TStaticSql.php, method TStaticSql::buildPreparedStatement()

top

## c

collect
  in file TMappedStatement.php, method TSqlMapObjectCollectionTree::collect()
collectChildren
  in file TMappedStatement.php, method TSqlMapObjectCollectionTree::collectChildren()
  Visit all the child nodes and collect them by removing.
create
  in file TPreparedCommand.php, method TPreparedCommand::create()
createCommand
  in file TCachingStatement.php, method TCachingStatement::createCommand()
createParametersForTextCommand
  in file TPreparedStatementFactory.php, method TPreparedStatementFactory::createParametersForTextCommand()

top

## e

enquequePostSelect
  in file TMappedStatement.php, method TMappedStatement::enquequePostSelect()
  Add nested result property to post select queue.
executeInsert
  in file TSelectMappedStatement.php, method TSelectMappedStatement::executeInsert()
executeInsert
  in file TUpdateMappedStatement.php, method TUpdateMappedStatement::executeInsert()
executeInsert
  in file TCachingStatement.php, method TCachingStatement::executeInsert()
executeInsert
  in file TMappedStatement.php, method TMappedStatement::executeInsert()
  Execute an insert statement. Fill the parameter object with the ouput parameters if any, also could return the insert generated key.
executePostSelect
  in file TMappedStatement.php, method TMappedStatement::executePostSelect()
  Process 'select' result properties
executeQueryForList
  in file TCachingStatement.php, method TCachingStatement::executeQueryForList()
executeQueryForList
  in file TUpdateMappedStatement.php, method TUpdateMappedStatement::executeQueryForList()
executeQueryForList
  in file IMappedStatement.php, method IMappedStatement::executeQueryForList()
  Executes the SQL and retuns a subset of the rows selected.
executeQueryForList
  in file TMappedStatement.php, method TMappedStatement::executeQueryForList()
  Executes the SQL and retuns a List of result objects.
executeQueryForList
  in file TInsertMappedStatement.php, method TInsertMappedStatement::executeQueryForList()
executeQueryForMap
  in file TMappedStatement.php, method TMappedStatement::executeQueryForMap()
  Executes the SQL and retuns all rows selected in a map that is keyed on the property named in the keyProperty parameter. The value at each key will be the value of the property specified in the valueProperty parameter.
executeQueryForMap
  in file TCachingStatement.php, method TCachingStatement::executeQueryForMap()
executeQueryForMap
  in file IMappedStatement.php, method IMappedStatement::executeQueryForMap()
  Executes the SQL and retuns all rows selected in a map that is keyed on
executeQueryForMap
  in file TUpdateMappedStatement.php, method TUpdateMappedStatement::executeQueryForMap()
executeQueryForMap
  in file TInsertMappedStatement.php, method TInsertMappedStatement::executeQueryForMap()
executeQueryForObject
  in file TUpdateMappedStatement.php, method TUpdateMappedStatement::executeQueryForObject()
executeQueryForObject
  in file IMappedStatement.php, method IMappedStatement::executeQueryForObject()
  Executes an SQL statement that returns a single row as an object of the type of the <tt>$result</tt> passed in as a parameter.
executeQueryForObject
  in file TMappedStatement.php, method TMappedStatement::executeQueryForObject()
  Executes an SQL statement that returns a single row as an object of the type of the <tt>$result</tt> passed in as a parameter.
executeQueryForObject
  in file TCachingStatement.php, method TCachingStatement::executeQueryForObject()
executeQueryForObject
  in file TInsertMappedStatement.php, method TInsertMappedStatement::executeQueryForObject()
executeSelectKey
  in file TMappedStatement.php, method TMappedStatement::executeSelectKey()
  Execute the select key statement, used to obtain last insert ID.
executeSQLQueryLimit
  in file TMappedStatement.php, method TMappedStatement::executeSQLQueryLimit()
  Execute SQL Query with limits.
executeUpdate
  in file TInsertMappedStatement.php, method TInsertMappedStatement::executeUpdate()
executeUpdate
  in file TCachingStatement.php, method TCachingStatement::executeUpdate()
executeUpdate
  in file TSelectMappedStatement.php, method TSelectMappedStatement::executeUpdate()
executeUpdate
  in file TMappedStatement.php, method TMappedStatement::executeUpdate()
  Execute an update statement. Also used for delete statement.
executeUpdate
  in file IMappedStatement.php, method IMappedStatement::executeUpdate()
  Execute an update statement. Also used for delete statement. Return the number of row effected.

top

## f

fillArrayResultMap
  in file TMappedStatement.php, method TMappedStatement::fillArrayResultMap()
  Retrieve the result map as an array.
fillDefaultResultMap
  in file TMappedStatement.php, method TMappedStatement::fillDefaultResultMap()
  Fill the result map using default settings. If <tt>$resultMap</tt> is null the result object returned will be guessed from <tt>$resultObject</tt>.
fillPropertyWithResultMap
  in file TMappedStatement.php, method TMappedStatement::fillPropertyWithResultMap()
  Fills the property with result mapping results.
fillResultArrayList
  in file TMappedStatement.php, method TMappedStatement::fillResultArrayList()
  Apply the result to a TList or an array.
fillResultClass
  in file TMappedStatement.php, method TMappedStatement::fillResultClass()
  Fill the result using ResultClass, will creates new result object if required.
fillResultMap
  in file TMappedStatement.php, method TMappedStatement::fillResultMap()
  Fills the result object according to result mappings.
fillResultObjectProperty
  in file TMappedStatement.php, method TMappedStatement::fillResultObjectProperty()
  Apply the result to an object.

top

## g

getCacheKey
  in file TCachingStatement.php, method TCachingStatement::getCacheKey()
getCollection
  in file TMappedStatement.php, method TSqlMapObjectCollectionTree::getCollection()
getCommand
  in file TMappedStatement.php, method TMappedStatement::getCommand()
getGenerate
  in file TSqlMapStatement.php, method TSqlMapSelect::getGenerate()
getID
  in file IMappedStatement.php, method IMappedStatement::getID()
getID
  in file TCachingStatement.php, method TCachingStatement::getID()
getID
  in file TMappedStatement.php, method TMappedStatement::getID()
getKey
  in file TMappedStatement.php, method TResultSetMapItemParameter::getKey()
getKeys
  in file TMappedStatement.php, method TPostSelectBinding::getKeys()
getList
  in file TMappedStatement.php, method TResultSetListItemParameter::getList()
getManager
  in file TCachingStatement.php, method TCachingStatement::getManager()
getManager
  in file TMappedStatement.php, method TMappedStatement::getManager()
getManager
  in file IMappedStatement.php, method IMappedStatement::getManager()
getMap
  in file TMappedStatement.php, method TResultSetMapItemParameter::getMap()
getMethod
  in file TMappedStatement.php, method TPostSelectBinding::getMethod()
getParameter
  in file TMappedStatement.php, method TResultSetListItemParameter::getParameter()
getParameter
  in file TMappedStatement.php, method TResultSetMapItemParameter::getParameter()
getParameterNames
  in file TPreparedStatement.php, method TPreparedStatement::getParameterNames()
getParameterValues
  in file TPreparedStatement.php, method TPreparedStatement::getParameterValues()
getPostGeneratedSelectKey
  in file TMappedStatement.php, method TMappedStatement::getPostGeneratedSelectKey()
  Gets the inserted row ID after executing an insert statement.
getPostSelectKeys
  in file TMappedStatement.php, method TMappedStatement::getPostSelectKeys()
  Finds in the post select property the SQL statement primary selection keys.
getPreGeneratedSelectKey
  in file TMappedStatement.php, method TMappedStatement::getPreGeneratedSelectKey()
  Gets the insert generated ID before executing an insert statement.
getPreparedSql
  in file TPreparedStatement.php, method TPreparedStatement::getPreparedSql()
getPreparedStatement
  in file TStaticSql.php, method TStaticSql::getPreparedStatement()
getResult
  in file TMappedStatement.php, method TResultSetListItemParameter::getResult()
getResultMapGroupKey
  in file TMappedStatement.php, method TMappedStatement::getResultMapGroupKey()
  Gets the result 'group by' groupping key for each row.
getResultObject
  in file TMappedStatement.php, method TPostSelectBinding::getResultObject()
getResultProperty
  in file TMappedStatement.php, method TPostSelectBinding::getResultProperty()
getScalarResult
  in file TMappedStatement.php, method TMappedStatement::getScalarResult()
  Converts the first array value to scalar value of given type.
getSqlString
  in file TMappedStatement.php, method TMappedStatement::getSqlString()
getStatement
  in file TMappedStatement.php, method TPostSelectBinding::getStatement()
getStatement
  in file TCachingStatement.php, method TCachingStatement::getStatement()
getStatement
  in file IMappedStatement.php, method IMappedStatement::getStatement()
getStatement
  in file TMappedStatement.php, method TMappedStatement::getStatement()
getValue
  in file TMappedStatement.php, method TResultSetMapItemParameter::getValue()

top

## h

hasChildren
  in file TMappedStatement.php, method TSqlMapObjectCollectionTree::hasChildren()

top

## i

IMappedStatement.php
  procedural page IMappedStatement.php
IMappedStatement
  in file IMappedStatement.php, class IMappedStatement
  Interface for all mapping statements.
initialGroupByResults
  in file TMappedStatement.php, method TMappedStatement::initialGroupByResults()
  Empty the group by results cache.
isEmpty
  in file TMappedStatement.php, method TSqlMapObjectCollectionTree::isEmpty()

top

## o

onChildNodesVisited
  in file TMappedStatement.php, method TSqlMapObjectCollectionTree::onChildNodesVisited()
  Set the object properties for all the child nodes visited.
onExecuteQuery
  in file TMappedStatement.php, method TMappedStatement::onExecuteQuery()
  Raise the execute query event.

top

## p

prepare
  in file TPreparedStatementFactory.php, method TPreparedStatementFactory::prepare()

top

## r

raiseRowDelegate
  in file TMappedStatement.php, method TMappedStatement::raiseRowDelegate()
  Raises delegate handler.
replaceDynamicParameter
  in file TSimpleDynamicSql.php, method TSimpleDynamicSql::replaceDynamicParameter()
runQueryForList
  in file TMappedStatement.php, method TMappedStatement::runQueryForList()
  Executes the SQL and retuns a List of result objects.
runQueryForMap
  in file TMappedStatement.php, method TMappedStatement::runQueryForMap()
  Executes the SQL and retuns all rows selected in a map that is keyed on the property named in the keyProperty parameter. The value at each key will be the value of the property specified in the valueProperty parameter.
runQueryForObject
  in file TMappedStatement.php, method TMappedStatement::runQueryForObject()
  Executes an SQL statement that returns a single row as an object of the type of the <tt>$result</tt> passed in as a parameter.

top

## s

setGenerate
  in file TSqlMapStatement.php, method TSqlMapSelect::setGenerate()
setKeys
  in file TMappedStatement.php, method TPostSelectBinding::setKeys()
setMethod
  in file TMappedStatement.php, method TPostSelectBinding::setMethod()
setObjectProperty
  in file TMappedStatement.php, method TMappedStatement::setObjectProperty()
  Set a property of the result object with appropriate value.
setParameterNames
  in file TPreparedStatement.php, method TPreparedStatement::setParameterNames()
setParameterValues
  in file TPreparedStatement.php, method TPreparedStatement::setParameterValues()
setPreparedSql
  in file TPreparedStatement.php, method TPreparedStatement::setPreparedSql()
setResultObject
  in file TMappedStatement.php, method TPostSelectBinding::setResultObject()
setResultProperty
  in file TMappedStatement.php, method TPostSelectBinding::setResultProperty()
setStatement
  in file TMappedStatement.php, method TPostSelectBinding::setStatement()

top

## t

TCachingStatement.php
  procedural page TCachingStatement.php
TDeleteMappedStatement.php
  procedural page TDeleteMappedStatement.php
TInsertMappedStatement.php
  procedural page TInsertMappedStatement.php
TMappedStatement.php
  procedural page TMappedStatement.php
TPreparedCommand.php
  procedural page TPreparedCommand.php
TPreparedStatementFactory.php
  procedural page TPreparedStatementFactory.php
TPreparedStatement.php
  procedural page TPreparedStatement.php
TSelectMappedStatement.php
  procedural page TSelectMappedStatement.php
TSimpleDynamicSql.php
  procedural page TSimpleDynamicSql.php
TStaticSql.php
  procedural page TStaticSql.php
TUpdateMappedStatement.php
  procedural page TUpdateMappedStatement.php
TCachingStatement
  in file TCachingStatement.php, class TCachingStatement
  TCacheingStatement class.
TDeleteMappedStatement
  in file TDeleteMappedStatement.php, class TDeleteMappedStatement
  TDeleteMappedStatement class.
TInsertMappedStatement
  in file TInsertMappedStatement.php, class TInsertMappedStatement
  TInsertMappedStatement class.
TMappedStatement
  in file TMappedStatement.php, class TMappedStatement
  TMappedStatement class executes SQL mapped statements. Mapped Statements can hold any SQL statement and use Parameter Maps and Result Maps for input and output.
TPostSelectBinding
  in file TMappedStatement.php, class TPostSelectBinding
  TPostSelectBinding class.
TPreparedCommand
  in file TPreparedCommand.php, class TPreparedCommand
  TPreparedCommand class.
TPreparedStatement
  in file TPreparedStatement.php, class TPreparedStatement
  TpreparedStatement class.
TPreparedStatementFactory
  in file TPreparedStatementFactory.php, class TPreparedStatementFactory
  TPreparedStatementFactory class.
TResultSetListItemParameter
  in file TMappedStatement.php, class TResultSetListItemParameter
  TResultSetListItemParameter class
TResultSetMapItemParameter
  in file TMappedStatement.php, class TResultSetMapItemParameter
  TResultSetMapItemParameter class.
TSelectMappedStatement
  in file TSelectMappedStatement.php, class TSelectMappedStatement
  TSelectMappedStatment class.
TSimpleDynamicSql
  in file TSimpleDynamicSql.php, class TSimpleDynamicSql
  TSimpleDynamicSql class.
TSqlMapObjectCollectionTree
  in file TMappedStatement.php, class TSqlMapObjectCollectionTree
  TSQLMapObjectCollectionTree class.
TSqlMapSelect
  in file TSqlMapStatement.php, class TSqlMapSelect
  TSqlMapSelect class file.
TStaticSql
  in file TStaticSql.php, class TStaticSql
  TStaticSql class.
TUpdateMappedStatement
  in file TUpdateMappedStatement.php, class TUpdateMappedStatement
  TUpdateMappedStatement class.

top

## u

QUERY_FOR_ARRAY
  in file TMappedStatement.php, class constant TMappedStatement::QUERY_FOR_ARRAY
QUERY_FOR_LIST
  in file TMappedStatement.php, class constant TMappedStatement::QUERY_FOR_LIST
QUERY_FOR_OBJECT
  in file TMappedStatement.php, class constant TMappedStatement::QUERY_FOR_OBJECT

top