| 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) * * * |