|
|
|
|
|
|
|
|
|
|
version 1.5
Contexts consist of binds between columns or expressions in an Oracle table and 4th Dimension fields, variables, or arrays. Once defined, contexts allow you to load Oracle data into 4th Dimension and update that information on the Oracle server without the use of SQL statements.
The context commands enable you to do the following:
• Create a context (OD Create context dialog, OD Create context),
• Define binds in a context (OD ADD TO CONTEXT),
• Add clauses to a context (OD EDIT CLAUSES IN CONTEXT, OD SET CLAUSE IN CONTEXT),
• Save or load a context definition (OD Save context picture, OD SAVE CONTEXT FILE, OD Open context picture, OD Open context file),
• Activate a context (OD Activate context),
• Synchronize a 4D selection with the rows of a context (OD Find in context),
• Load Oracle rows into 4th Dimension (OD Next in context, OD Previous in context, OD Goto in context, OD Load rows context),
• Update, insert, and delete data (OD Update in context, OD Insert in context, OD Delete in context),
• Retrieve information about the context (OD Context state, OD Records in context, OD Number in context, OD Get clause in context),
• Deactivate or close a context (OD DEACTIVATE CONTEXT, OD DROP CONTEXT, OD Reset context).
You can create a context either by using a dialog box or by executing a set of procedural statements. For more information on either method, refer to section Using Contexts.
A context involving more than one table or containing a GROUP BY or DISTINCT clause can only be browsed. In this case, you cannot use the data modification commands, OD Insert in context, OD Update in context, and OD DELETE IN CONTEXT, to update the data in the Oracle tables.
A context involving more than one table or containing a GROUP BY clause cannot use the rowid column with OD Previous in context or OD Goto in context to move from row to row. You may specify a primary key in order to use these commands.
|
|
|
|
|
|
|
|
|
|