Interface for building UPDATE statements. More...
import"sbISQLBuilder.idl";
Public Member Functions | |
| void | addAssignmentString (in AString aColumnName, in AString aValue) |
| Add a string assignment to the set clause. More... | |
| void | addAssignmentParameter (in AString aColumnName) |
| Add a parameter assignment to the set clause. More... | |
 Public Member Functions inherited from sbISQLWhereBuilder | |
| void | addCriterion (in sbISQLBuilderCriterion aCriterion) |
| Add a criteria constraint to the query. More... | |
| void | removeCriterion (in sbISQLBuilderCriterion aCriterion) |
| Remve a criteria constraint from the query. More... | |
| sbISQLBuilderCriterion | createMatchCriterionString (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType, in AString aValue) |
| Create a match criterion with an AString datatype. More... | |
| sbISQLBuilderCriterion | createMatchCriterionBetweenString (in AString aTableName, in AString aSrcColumnName, in AString aLeftValue, in AString aRightValue) |
| sbISQLBuilderCriterion | createMatchCriterionNotBetweenString (in AString aTableName, in AString aSrcColumnName, in AString aLeftValue, in AString aRightValue) |
| sbISQLBuilderCriterion | createMatchCriterionLong (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType, in long aValue) |
| Create a match criterion with a long (32 bit) datatype. More... | |
| sbISQLBuilderCriterion | createMatchCriterionLongLong (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType, in long long aValue) |
| Create a match criterion with a long long (64 bit) datatype. More... | |
| sbISQLBuilderCriterion | createMatchCriterionNull (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType) |
| Create a match criterion that tests against the null value. More... | |
| sbISQLBuilderCriterion | createMatchCriterionTable (in AString aLeftTableName, in AString aLeftColumnName, in unsigned long aMatchType, in AString aRightTableName, in AString aRightColumnName) |
| Create a match criterion that tests against a table column. More... | |
| sbISQLBuilderCriterionIn | createMatchCriterionIn (in AString aTableName, in AString aSrcColumnName) |
| Create a match criterion using the IN() operator. More... | |
| sbISQLBuilderCriterion | createMatchCriterionParameter (in AString aTableName, in AString aSrcColumnName, in unsigned long aMatchType) |
| Create a match criterion that tests against a parameter placeholder. More... | |
| sbISQLBuilderCriterion | createAndCriterion (in sbISQLBuilderCriterion aLeft, in sbISQLBuilderCriterion aRight) |
| Create a match criterion that is the logical AND of two critera. More... | |
| sbISQLBuilderCriterion | createOrCriterion (in sbISQLBuilderCriterion aLeft, in sbISQLBuilderCriterion aRight) |
| Create a match criterion that is the logical OR of two critera. More... | |
| Public Member Functions inherited from sbISQLBuilder | |
| void | addJoin (in unsigned long aJoinType, in AString aJoinedTableName, in AString aJoinedTableAlias, in AString aJoinedColumnName, in AString aJoinToTableName, in AString aJoinToColumnName) |
| Add a join to the query. More... | |
| void | addJoinWithIndexHint (in unsigned long aJoinType, in AString aJoinedTableName, in AString aJoinedTableAlias, in AString aJoinedColumnName, in AString aJoinToTableName, in AString aJoinToColumnName, in boolean aRequiresFromTableIndexHint, in boolean aRequiresToTableIndexHint) |
| Add a join to the query. More... | |
| void | addSubqueryJoin (in unsigned long aJoinType, in sbISQLSelectBuilder aJoinedSubquery, in AString aJoinedTableAlias, in AString aJoinedColumnName, in AString aJoinToTableName, in AString aJoinToColumnName) |
| Add a subquery join join to the query. More... | |
| void | addJoinWithCriterion (in unsigned long aJoinType, in AString aJoinedTableName, in AString aJoinedTableAlias, in sbISQLBuilderCriterion aCriterion) |
| Add a join to the query with a critera object specifcying the join constraints. More... | |
| void | addSubquery (in sbISQLSelectBuilder aSubquery, in AString aAlias) |
| Add a subquery to the from clause. More... | |
| void | reset () |
| Clears out query configuration to this instance can be reused. More... | |
| AString | toString () |
| Return the generated SQL statement for the query. More... | |
Public Attributes | |
| attribute AString | tableName |
| Table to update. More... | |
| Public Attributes inherited from sbISQLBuilder | |
| const unsigned long | MATCH_EQUALS = 0 |
| const unsigned long | MATCH_NOTEQUALS = 1 |
| const unsigned long | MATCH_GREATER = 2 |
| const unsigned long | MATCH_GREATEREQUAL = 3 |
| const unsigned long | MATCH_LESS = 4 |
| const unsigned long | MATCH_LESSEQUAL = 5 |
| const unsigned long | MATCH_LIKE = 6 |
| const unsigned long | MATCH_NOTLIKE = 7 |
| const unsigned long | MATCH_MATCH = 8 |
| attribute long | limit |
| Value for the limit clause. More... | |
| attribute boolean | limitIsParameter |
| Is the limit clause a parameter? More... | |
| attribute long | offset |
| Value for the offset clause. More... | |
| attribute boolean | offsetIsParameter |
| Is the offset clause a parameter? More... | |
| const unsigned long | JOIN_INNER = 0 |
| const unsigned long | JOIN_LEFT = 1 |
| const unsigned long | JOIN_LEFT_OUTER = 2 |
Interface for building UPDATE statements.
Definition at line 429 of file sbISQLBuilder.idl.
| void sbISQLUpdateBuilder::addAssignmentParameter | ( | in AString | aColumnName | ) |
Add a parameter assignment to the set clause.
| aColumnName | Column to set |
| void sbISQLUpdateBuilder::addAssignmentString | ( | in AString | aColumnName, |
| in AString | aValue | ||
| ) |
Add a string assignment to the set clause.
| aColumnName | Column to set |
| aValue | String value to set the column to |
| attribute AString sbISQLUpdateBuilder::tableName |
Table to update.
Definition at line 434 of file sbISQLBuilder.idl.
