OD SET CLAUSE IN CONTEXT

version 1.5

OD SET CLAUSE IN CONTEXT (context_ID; clauseNumber; clause)

Parameter	Type		Description
context_ID	Longint		Context identifier
clauseNumber	Integer		Number of clause to set
clause	String		Text of clause

The OD SET CLAUSE IN CONTEXT command accomplishes procedurally what OD EDIT CLAUSES IN CONTEXT allows you to do graphically.

You should use OD SET CLAUSE IN CONTEXT when you do not want users to build their own clauses. If you would like users to have some control over the clauses, but want to create a different interface for entering the clauses, you can specify a variable containing the clause in the clause parameter.

OD SET CLAUSE IN CONTEXT defines a clause in a context. context_ID must be the identifier for a previously created and inactive context.

clauseNumber is a number representing the clause you want to define:

Clause Number	Clause
2	WHERE
3	GROUP BY
4	HAVING
5	CONNECT BY
6	START WITH

clause is the text of the clause without the associated keyword (i.e. without the "WHERE" or other keyword).

The following statement creates a WHERE clause that can be used to search for employees in department number 30:

   OD SET CLAUSE IN CONTEXT (Context_ID;2;"DEPTNO = 30")

OD EDIT CLAUSES IN CONTEXT, OD Get clause in context.