OD EDIT CLAUSES IN CONTEXT

version 1.5

OD EDIT CLAUSES IN CONTEXT (login_ID; context_ID)

Parameter	Type		Description
login_ID	Longint		Connection identifier
context_ID	Longint		Context identifier

The OD EDIT CLAUSES IN CONTEXT command displays the Edit a SQL Clause dialog box, allowing you to edit the clauses of the specified context.

login_ID must be a valid connection identifier that is used to load the list of tables and columns that you can access.

context_ID must be a previously created, inactive context identifier.

Using the dialog box, you can modify the following clauses:

WHERE,

GROUP BY,

HAVING,

CONNECT BY,

START WITH.

The following method creates a context and then displays a dialog box allowing you to specify a clause for the context:

   Context_ID := OD Create context ("EMP")   `Creates a context
   OD ADD TO CONTEXT (Context_ID;"empno";->[Employees]No;0)
   OD ADD TO CONTEXT (Context_ID;"ename";->[Employees]Name;0)   `Defines the binds
   OD EDIT CLAUSES IN CONTEXT (Login_ID;Context_ID)   `Lets you personalize the query

OD Get clause in context, OD SET CLAUSE IN CONTEXT.

If the user clicks OK in the dialog box, the OK system variable is set to 1. If the user clicks Cancel, the OK system variable is set to 0.