Try OpenEdge Now
skip to main content
Java Open Clients
Passing Temp-tables as SQL ResultSet Parameters : Preparing and managing temp-table parameters : Accessing temp-table array fields : Using the array model
 
Using the array model
The array model methods behave as follows:
*getFieldCount() returns the value 3
*getFieldProType(2) gets the data type of the second TABLE field
*getFieldProType(3) gets the data type of the third TABLE field
In this model, since all elements of an array field have the same meta data information, it is necessary to pass only the field index (without an array item index) to these meta data methods. For methods that get a field value, each method has an extra parameter to specify an array index. For example, the method to get the value of a field as an object is as follows:
getObject(int fieldNum, int arrayIndex)