sbISQLInsertBuilder Interface Reference

Interface for building INSERT statements. More...

import"sbISQLBuilder.idl";

Inheritance diagram for sbISQLInsertBuilder:
[legend]
Collaboration diagram for sbISQLInsertBuilder:
[legend]

Public Member Functions

void addColumn (in AString aColumnName)
 Add a column to the insert list. More...
 
void addValueString (in AString aValue)
 Add a string value to the value list. More...
 
void addValueLong (in long aValue)
 Add a long value to the value list. More...
 
void addValueNull ()
 Add a null to the value list. More...
 
void addValueParameter ()
 Add a parameter to the value list. More...
 
void addValueRaw (in AString aValue)
 Add a raw string the value list. Note that this does not do any escaping of the value so please only use this if you know what you are doing. 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 intoTableName
 Table to insert into. More...
 
attribute sbISQLSelectBuilder select
 Select statement to use as the source of data for the insert. This can be used in place of the value list. 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
 

Detailed Description

Interface for building INSERT statements.

Definition at line 375 of file sbISQLBuilder.idl.

Member Function Documentation

void sbISQLInsertBuilder::addColumn ( in AString  aColumnName)

Add a column to the insert list.

Parameters
aColumnNameThe name of the column to add to the list
void sbISQLInsertBuilder::addValueLong ( in long  aValue)

Add a long value to the value list.

Parameters
aValueLong value to add
void sbISQLInsertBuilder::addValueNull ( )

Add a null to the value list.

void sbISQLInsertBuilder::addValueParameter ( )

Add a parameter to the value list.

void sbISQLInsertBuilder::addValueRaw ( in AString  aValue)

Add a raw string the value list. Note that this does not do any escaping of the value so please only use this if you know what you are doing.

void sbISQLInsertBuilder::addValueString ( in AString  aValue)

Add a string value to the value list.

Parameters
aValueString value to add

Member Data Documentation

attribute AString sbISQLInsertBuilder::intoTableName

Table to insert into.

Definition at line 415 of file sbISQLBuilder.idl.

attribute sbISQLSelectBuilder sbISQLInsertBuilder::select

Select statement to use as the source of data for the insert. This can be used in place of the value list.

Definition at line 421 of file sbISQLBuilder.idl.


The documentation for this interface was generated from the following file: