Loading The Selected Data

version 1.5

Once you have selected data on the Oracle server, you can display it by loading it into 4th Dimension fields, variables, or arrays. When you load data, you can choose to load one row at a time or several rows at once.

To load one row, you can execute an OD Next in context, OD Previous in context, or OD Goto in context statement. For example, to display the next row in a context, you can use the following statement:

   $res:=OD Next in context (myContext)

The row is displayed in the 4th Dimension objects specified in the context.

If you know the number of the row you want to load, you can load it using a statement such as:

   $res:=OD Goto in context (myContext;12)

To load several rows at once, you can execute an OD Load rows context statement. In this case, 4D for Oracle loads all of the rows, creating records or array lines as needed.

If necessary, you can limit the maximum number of rows that can be loaded at once. For instance, the following statement loads the first 100 rows selected by the context:

   $res:=OD Load rows context (myContext;100)

We recommend that you load data into variables or arrays, as you do not need to save a copy of the data on the client machine. In most applications, data is saved exclusively on the Oracle server.