Class Finder
Namespace: System.Data.Common
Inheritance: TComponent » TDbCommandBuilder »
TMssqlCommandBuilder
Properties | Events | Methods | Derived classes | All classes
Properties
 NameTypeDescription
  DbConnection TDbConnection database connection. (inherited from TDbCommandBuilder)
R LastInsertID integer Overrides parent implementation.
R SelectFieldList array Different behavior depends on type of passed data string usage without modification null will be expanded to full list of quoted table column names (quoting depends on database) array - Column names will be quoted if used as key or value of array array('col1', 'col2', 'col2') // SELECT `col1`, `col2`, `col3` FROM. (inherited from TDbCommandBuilder)
  TableInfo {unknown} . (inherited from TDbCommandBuilder)
Events
Methods
 NameDescription
  addParsedObject Processes an object that is created during parsing template. (inherited from TComponent)
  applyCriterias . (inherited from TDbCommandBuilder)
  applyLimitOffset Overrides parent implementation.
  applyOrdering modified SQL applied with ORDER BY. (inherited from TDbCommandBuilder)
  attachEventHandler Attaches an event handler to an event. (inherited from TComponent)
  bindArrayValues . (inherited from TDbCommandBuilder)
  bindColumnValues Bind the name-value pairs of $values where the array keys correspond to column names. (inherited from TDbCommandBuilder)
  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. (inherited from TDbCommandBuilder)
  createCountCommand Creates a count(*) command for the table described in TableInfo. (inherited from TDbCommandBuilder)
  createDeleteCommand Creates a delete command for the table described in TableInfo. (inherited from TDbCommandBuilder)
  createFindCommand Appends the $where condition to the string "SELECT * FROM tableName WHERE ". (inherited from TDbCommandBuilder)
  createInsertCommand Creates an insert command for the table described in TableInfo for the given data. (inherited from TDbCommandBuilder)
  createUpdateCommand Creates an update command for the table described in TableInfo for the given data. (inherited from TDbCommandBuilder)
  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 findOrdering Base on simplified syntax http://msdn2.
P getColumnBindings Create a name-value or position-value if $position=true binding strings. (inherited from TDbCommandBuilder)
  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. (inherited from TDbCommandBuilder)
S getPdoType PDO parameter types. (inherited from TDbCommandBuilder)
P getSearchCondition search condition for all words in one column. (inherited from 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). (inherited from TDbCommandBuilder)
  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. (inherited from TDbCommandBuilder)
  hasProperty Determines whether a property is defined. (inherited from TComponent)
P joinOrdering concat the orderings.
  raiseEvent Raises an event. (inherited from TComponent)
P reverseDirection ordering with reversed direction.
P rewriteLimitOffsetSql Rewrite sql to apply $limit > and $offset > 0 for MSSQL database.
  setSubProperty Sets a value to a property path. (inherited from TComponent)
Derived classes