Home
About
Testimonials
Demos
Download
Documentation
Forum
Development
Class Finder
Tutorials
Class Docs
API Manual
Wiki
Namespace:
System.Data.SqlMap.Statements
Inheritance:
TComponent
»
TMappedStatement
»
TSelectMappedStatement
Properties
|
Events
|
Methods
|
Derived classes
|
All classes
Properties
Name
Type
Description
R
Command
TPreparedCommand
command to prepare SQL statements. (inherited from
TMappedStatement
)
R
ID
string
Name used to identify the TMappedStatement amongst the others. (inherited from
TMappedStatement
)
R
Manager
TSqlMapper
The SqlMap used by this MappedStatement. (inherited from
TMappedStatement
)
R
SqlString
{unknown}
. (inherited from
TMappedStatement
)
R
Statement
TSqlMapStatement
The SQL statment used by this MappedStatement. (inherited from
TMappedStatement
)
Events
Name
Description
OnExecuteQuery
Raise the execute query event. (inherited from
TMappedStatement
)
Methods
Name
Description
addParsedObject
Processes an object that is created during parsing template. (inherited from
TComponent
)
P
addResultMapGroupBy
ResultMap with GroupBy property. (inherited from
TMappedStatement
)
P
applyResultMap
Apply result mapping. (inherited from
TMappedStatement
)
attachEventHandler
Attaches an event handler to an event. (inherited from
TComponent
)
canGetProperty
Determines whether a property can be read. (inherited from
TComponent
)
canSetProperty
Determines whether a property can be set. (inherited from
TComponent
)
createdOnTemplate
This method is invoked after the component is instantiated by a template. (inherited from
TComponent
)
detachEventHandler
Detaches an existing event handler. (inherited from
TComponent
)
P
enquequePostSelect
Add nested result property to post select queue. (inherited from
TMappedStatement
)
evaluateExpression
Evaluates a PHP expression in the context of this control. (inherited from
TComponent
)
evaluateStatements
Evaluates a list of PHP statements. (inherited from
TComponent
)
executeInsert
.
P
executePostSelect
Process 'select' result properties . (inherited from
TMappedStatement
)
executeQueryForList
Executes the SQL and retuns a List of result objects. (inherited from
TMappedStatement
)
executeQueryForMap
Executes the SQL and retuns all rows selected in a map that is keyed on the property named in the keyProperty parameter. (inherited from
TMappedStatement
)
executeQueryForObject
Executes an SQL statement that returns a single row as an object of the type of the
$result
passed in as a parameter. (inherited from
TMappedStatement
)
P
executeSQLQueryLimit
Execute SQL Query with limits. (inherited from
TMappedStatement
)
P
executeSelectKey
Execute the select key statement, used to obtain last insert ID. (inherited from
TMappedStatement
)
executeUpdate
.
P
fillArrayResultMap
Retrieve the result map as an array. (inherited from
TMappedStatement
)
P
fillDefaultResultMap
Fill the result map using default settings. (inherited from
TMappedStatement
)
P
fillPropertyWithResultMap
Fills the property with result mapping results. (inherited from
TMappedStatement
)
P
fillResultArrayList
Apply the result to a TList or an array. (inherited from
TMappedStatement
)
P
fillResultClass
Fill the result using ResultClass, will creates new result object if required. (inherited from
TMappedStatement
)
P
fillResultMap
Fills the result object according to result mappings. (inherited from
TMappedStatement
)
P
fillResultObjectProperty
Apply the result to an object. (inherited from
TMappedStatement
)
getEventHandlers
Returns the list of attached event handlers for an event. (inherited from
TComponent
)
P
getPostGeneratedSelectKey
Gets the inserted row ID after executing an insert statement. (inherited from
TMappedStatement
)
P
getPostSelectKeys
Finds in the post select property the SQL statement primary selection keys. (inherited from
TMappedStatement
)
P
getPreGeneratedSelectKey
Gets the insert generated ID before executing an insert statement. (inherited from
TMappedStatement
)
P
getResultMapGroupKey
Gets the result 'group by' groupping key for each row. (inherited from
TMappedStatement
)
P
getScalarResult
Converts the first array value to scalar value of given type. (inherited from
TMappedStatement
)
getSubProperty
Evaluates a property path. (inherited from
TComponent
)
hasEvent
Determines whether an event is defined. (inherited from
TComponent
)
hasEventHandler
whether an event has been attached one or several handlers. (inherited from
TComponent
)
hasProperty
Determines whether a property is defined. (inherited from
TComponent
)
P
initialGroupByResults
Empty the group by results cache. (inherited from
TMappedStatement
)
raiseEvent
Raises an event. (inherited from
TComponent
)
P
raiseRowDelegate
Raises delegate handler. (inherited from
TMappedStatement
)
runQueryForList
Executes the SQL and retuns a List of result objects. (inherited from
TMappedStatement
)
runQueryForMap
Executes the SQL and retuns all rows selected in a map that is keyed on the property named in the keyProperty parameter. (inherited from
TMappedStatement
)
runQueryForObject
Executes an SQL statement that returns a single row as an object of the type of the
$result
passed in as a parameter. (inherited from
TMappedStatement
)
P
setObjectProperty
Set a property of the result object with appropriate value. (inherited from
TMappedStatement
)
setSubProperty
Sets a value to a property path. (inherited from
TComponent
)
Derived classes