Package | Description |
---|---|
com.irisel.oms.olapi | |
com.irisel.oms.sql |
Modifier and Type | Method and Description |
---|---|
void |
QueryTree.setTarget(int branchIndex,
Field[] fields)
WARNING! First field must be PK
|
Modifier and Type | Method and Description |
---|---|
Field |
Filter.getField1()
Returns the left-hand value of this filter.
|
Field |
Filter.getField2()
Returns the (field) right-hand value of this filter.
|
Field |
Filter.getField2b()
Returns the second (field) right-hand value of this filter.
|
static Field[] |
Field.getFields(java.lang.String classname,
java.lang.String[] propertynames) |
Field[] |
Query.getTarget()
Returns array of target fields: fields selected, updated, etc.
|
Modifier and Type | Method and Description |
---|---|
void |
Query.addFilter(Field f,
int op) |
void |
SelectQuery.orderBy(Field[] fieldOrds,
int[] ascOrDescOperator) |
void |
SelectQuery.orderBy(Field fieldOrd,
int operator) |
void |
Filter.setField1(Field newField1)
Sets the left-hand field of this filter.
|
void |
Filter.setField2(Field newField2)
Sets the right-hand field of this filter.
|
void |
Filter.setField2b(Field newField2b)
Sets the right-hand secondary field of this filter.
|
void |
Query.setFilter(Field f,
int op) |
void |
Query.setTarget(Field newTarget)
Set target fields.
|
void |
Query.setTarget(Field[] newTarget)
Set target fields.
|
Constructor and Description |
---|
AlterTableQuery(Field[] target)
Constructor
Creation date: (21/10/02 21:54:21)
|
AlterTableQuery(Field[] target,
Filter[][] filters)
Constructor
Creation date: (21/10/02 21:54:21)
|
AlterTableQuery(Field[] target,
Filter[][][] filters) |
AlterTableQuery(Field[] target,
Filter[][][] filters,
Option[] options) |
AlterTableQuery(Field[] target,
Filter[][] filters,
Option[] options)
Constructor
Creation date: (21/10/02 21:54:21)
|
CreateTableQuery(Field[] target)
Constructor
Creation date: (21/10/02 21:54:21)
|
CreateTableQuery(Field[] target,
Filter[][] filters)
Constructor
Creation date: (21/10/02 21:54:21)
|
CreateTableQuery(Field[] target,
Filter[][][] filters) |
CreateTableQuery(Field[] target,
Filter[][][] filters,
Option[] options) |
CreateTableQuery(Field[] target,
Filter[][] filters,
Option[] options)
Constructor
Creation date: (21/10/02 21:54:21)
|
DeleteQuery(Field field) |
DeleteQuery(Field target,
Filter filter) |
DeleteQuery(Field target,
Filter[][] filters)
Constructor
Creation date: (21/10/02 21:54:21)
|
DropTableQuery(Field[] target)
Constructor
Creation date: (21/10/02 21:54:21)
|
DropTableQuery(Field[] target,
Filter[][] filters)
Constructor
Creation date: (21/10/02 21:54:21)
|
DropTableQuery(Field[] target,
Filter[][] filters,
Option[] options)
Constructor
Creation date: (21/10/02 21:54:21)
|
Filter(Field f1,
int op)
Constructor for filters of the form: tableA.field1 = field1.value
|
Filter(Field f1,
int op,
Field f2)
Constructor for filters of the form: tableA.field1 = tableB.field2
|
Filter(Field f1,
int op,
Query q2)
Constructor for filters of the form: tableA.field1 IN ( select field1 from tableB where ...)
|
InsertQuery(Field[] target)
Constructor
Creation date: (21/10/02 21:54:21)
|
Query(int keyword,
Field[] target,
Filter[][][] filters,
Option[] options) |
Query(int keyword,
Field[] target,
Filter[][] filters,
Option[] options)
Constructor
Creation date: (21/10/02 21:54:21)
|
SelectQuery(Field[] target)
Constructor
Creation date: (21/10/02 21:54:21)
|
SelectQuery(Field[] target,
Filter[][] filters)
Constructor
Creation date: (21/10/02 21:54:21)
|
SelectQuery(Field[] target,
Filter[][][] filters) |
SelectQuery(Field[] target,
Filter[][][] filters,
Option[] options)
Constructor
Creation date: (21/10/02 21:54:21)
|
SelectQuery(Field[] target,
Filter[][] filters,
Option[] options) |
UpdateQuery(Field[] target)
* * * Constructor * * * Creation date: (21/10/02 21:54:21) * * *
|
UpdateQuery(Field[] target,
Filter[][] filters)
* * * Constructor * * * Creation date: (21/10/02 21:54:21) * * *
|
UpdateQuery(Field[] target,
Filter[][][] filters) |
UpdateQuery(Field[] target,
Filter[][] filters,
Option[] options)
* * * Constructor * * * Creation date: (21/10/02 21:54:21) * * *
|