Modifying a query

You can perform the following manipulations when modifying a query.

Adding or deleting a table

• set(String dataSourceName, String qryName, String tablename, String columnname, boolean isFormula)
  Adds a new table to a query and returns a Boolean value: true if successful, otherwise false.
• deleteQueryTable(String dataSourceName, String qryName, String tablename)
  Deletes the selected table in a query and returns a Boolean value: true if successful, otherwise false.

Parameters

• qryName - The query name.
• tablename - The name of the table that is to be inserted or deleted.
• selectAllFields - Specifies whether or not to insert a table with all its fields.

Adding or deleting a field

• set(String dataSourceName, String qryName, String tablename, String columnname, boolean isFormula)
  Adds a new field to a query and returns a Boolean value: true if successful, otherwise false.
• deleteQueryField(String dataSourceName, String qryName, String tablename, String columnname)
  Deletes the selected fields in a query and returns a Boolean value: true if successful, otherwise false.

Parameters

• qryName - The query name.
• tablename - The table name of the inserted or deleted field.
• isFormula - Indicates whether the inserted field is a formula.
• columnname - The column name of the deleted field.

Adding or deleting a join

• set(String dataSourceName, String qryName, String tableFrom, String columnFrom, String operator, String tableTo, String columnTo, boolean isSQL92, int outerJoin)
  Adds a new join to a query and returns a Boolean value: true if successful, otherwise false.
• deleteQueryJoin(String dataSourceName, String qryName, String tableFrom, String columnFrom, String operator, String tableTo, String columnTo)
  Deletes joins in a query and returns a Boolean value: true if successful, otherwise false.

Parameters

• qryName - The query name.
• tableFrom - The name of the table from which the join links.
• columFrom - The name of the column from which the join links.
• tableTo - The name of the table to which the join links.
• columnTo - The name of the column to which the join links.
• operator - Operator of the join to be inserted or deleted.

Adding or deleting a QBE condition

• setQBE(String dataSourceName, String qryName, String tablename, String columnname, String expression)
  Adds a new QBE condition to a query and returns a Boolean value: true if successful, otherwise false.
• deleteQBE(String dataSourceName, String qryName, String tablename, String columnname, String expression)
  Deletes the QBE condition in a query and returns a Boolean value: true if successful, otherwise false.

Parameters

• qryName - The query name.
• tablename - The name of the table where the QBE condition will be added or deleted.
• columnname - The name of the column where the QBE condition will be added or deleted.
• expression - The expression of the QBE condition.

Adding or Deleting a where condition

• setCondition(String dataSourceName, String qryName, String sExpression1, String sOperator, String sExpression2, String sLogic)
  Adds a new where condition to a query and returns a Boolean value: true if successful, otherwise false.
• deleteCondition(String dataSourceName, String qryName, String sExpression1, String sOperator, String sExpression2, String sLogic)
  Deletes the where conditions in a query and returns a Boolean value: true if successful, otherwise false.

Parameters

• qryName - The query handle.
• sLogic - The logic string of the where condition that is to be inserted or deleted.
• sExpression1 - The first expression of the where condition that is to be inserted or deleted.
• sOperator - The operator of the where condition that is to be inserted or deleted.
• sExpression2 - The second expression of the where condition that is to be inserted or deleted.