Home
About
Testimonials
Demos
Download
Documentation
Forum
Development
Class Finder
Tutorials
Class Docs
API Manual
Wiki
Namespace:
System.Data.Common
Inheritance:
TComponent
»
TDbCommandBuilder
Properties
|
Events
|
Methods
|
Derived classes
|
All classes
Properties
Name
Type
Description
DbConnection
TDbConnection
database connection.
R
LastInsertID
mixed
Iterate through all the columns and returns the last insert id of the first column that has a sequence or serial.
TableInfo
{unknown}
.
Events
Methods
Name
Description
addParsedObject
Processes an object that is created during parsing template. (inherited from
TComponent
)
applyCriterias
.
applyLimitOffset
Alters the sql to apply $limit and $offset.
applyOrdering
modified SQL applied with ORDER BY.
attachEventHandler
Attaches an event handler to an event. (inherited from
TComponent
)
bindArrayValues
.
bindColumnValues
Bind the name-value pairs of $values where the array keys correspond to column names.
canGetProperty
Determines whether a property can be read. (inherited from
TComponent
)
canSetProperty
Determines whether a property can be set. (inherited from
TComponent
)
createCommand
corresponding database command.
createCountCommand
Creates a count(*) command for the table described in TableInfo.
createDeleteCommand
Creates a delete command for the table described in TableInfo.
createFindCommand
Appends the $where condition to the string "SELECT * FROM tableName WHERE ".
createInsertCommand
Creates an insert command for the table described in TableInfo for the given data.
createUpdateCommand
Creates an update command for the table described in TableInfo for the given data.
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
)
evaluateExpression
Evaluates a PHP expression in the context of this control. (inherited from
TComponent
)
evaluateStatements
Evaluates a list of PHP statements. (inherited from
TComponent
)
P
getColumnBindings
Create a name-value or position-value if $position=true binding strings.
getEventHandlers
Returns the list of attached event handlers for an event. (inherited from
TComponent
)
P
getInsertFieldBindings
Returns a list of insert field name and a list of binding names.
S
getPdoType
PDO parameter types.
P
getSearchCondition
search condition for all words in one column.
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).
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
)
P
hasIntegerKey
true if any array key is an integer.
hasProperty
Determines whether a property is defined. (inherited from
TComponent
)
raiseEvent
Raises an event. (inherited from
TComponent
)
setSubProperty
Sets a value to a property path. (inherited from
TComponent
)
Derived classes
TMssqlCommandBuilder
TMysqlCommandBuilder
TOracleCommandBuilder
TPgsqlCommandBuilder
TSqliteCommandBuilder
Mortgages
|
Per Insurance
|
Payday Loans
|
MPAA
|
Loans