Home
About
Testimonials
Demos
Download
Documentation
Forum
Development
Class Finder
Tutorials
Class Docs
API Manual
Wiki
Namespace:
System.Data.SqlMap.Statements
Inheritance:
TComponent
»
TMappedStatement
Properties
|
Events
|
Methods
|
Derived classes
|
All classes
Properties
Name
Type
Description
R
Command
TPreparedCommand
command to prepare SQL statements.
R
ID
string
Name used to identify the TMappedStatement amongst the others.
R
Manager
TSqlMapper
The SqlMap used by this MappedStatement.
R
SqlString
{unknown}
.
R
Statement
TSqlMapStatement
The SQL statment used by this MappedStatement.
Events
Name
Description
OnExecuteQuery
Raise the execute query event.
Methods
Name
Description
addParsedObject
Processes an object that is created during parsing template. (inherited from
TComponent
)
P
addResultMapGroupBy
ResultMap with GroupBy property.
P
applyResultMap
Apply result mapping.
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.
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
Execute an insert statement.
P
executePostSelect
Process 'select' result properties .
executeQueryForList
Executes the SQL and retuns a List of result objects.
executeQueryForMap
Executes the SQL and retuns all rows selected in a map that is keyed on the property named in the keyProperty parameter.
executeQueryForObject
Executes an SQL statement that returns a single row as an object of the type of the
$result
passed in as a parameter.
P
executeSQLQueryLimit
Execute SQL Query with limits.
P
executeSelectKey
Execute the select key statement, used to obtain last insert ID.
executeUpdate
Execute an update statement.
P
fillArrayResultMap
Retrieve the result map as an array.
P
fillDefaultResultMap
Fill the result map using default settings.
P
fillPropertyWithResultMap
Fills the property with result mapping results.
P
fillResultArrayList
Apply the result to a TList or an array.
P
fillResultClass
Fill the result using ResultClass, will creates new result object if required.
P
fillResultMap
Fills the result object according to result mappings.
P
fillResultObjectProperty
Apply the result to an object.
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.
P
getPostSelectKeys
Finds in the post select property the SQL statement primary selection keys.
P
getPreGeneratedSelectKey
Gets the insert generated ID before executing an insert statement.
P
getResultMapGroupKey
Gets the result 'group by' groupping key for each row.
P
getScalarResult
Converts the first array value to scalar value of given type.
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.
raiseEvent
Raises an event. (inherited from
TComponent
)
P
raiseRowDelegate
Raises delegate handler.
runQueryForList
Executes the SQL and retuns a List of result objects.
runQueryForMap
Executes the SQL and retuns all rows selected in a map that is keyed on the property named in the keyProperty parameter.
runQueryForObject
Executes an SQL statement that returns a single row as an object of the type of the
$result
passed in as a parameter.
P
setObjectProperty
Set a property of the result object with appropriate value.
setSubProperty
Sets a value to a property path. (inherited from
TComponent
)
Derived classes
TInsertMappedStatement
TSelectMappedStatement
TUpdateMappedStatement
Mortgage Loans
|
Mortgages
|
The eBay Song
|
Libros
|
Car Finance