package Selection;

import j4d.open.*;

class Examplet {

  /* doArrayToSelection return an opSelection that contains all records of the target table
  */
  public void doArrayToSelection(opProcess process) throws opException {

    int mTargetTable = 3;
    opSelection mSelection;

    try{
      //create an empty selection on table 3
      mSelection = new opSelection(mTargetTable);
      mSelection.mRecordsInSelection = 0;
      process.ReduceSelection(MySelect);

      //creating an array of 2 fields that will contains the data
      opFieldArray mFieldTab = new opFieldArray(2);
      mFieldTab.mTargetTable = mTargetTable;
      mFieldTab.mFieldArray[0].mFieldNumber = 1;
      mFieldTab.mFieldArray[0].mFieldType = (byte) ALPHANUMERIC;
      mFieldTab.mFieldArray[1].mFieldNumber = 2;
      mFieldTab.mFieldArray[1].mFieldType = (byte) INTEGER;

      //Fill the data to send
      opDataArray mTabDataArray[] = new opDataArray[2];
      mTabDataArray[0] = new opDataArray(3); //the names
      mTabDataArray[1] = new opDataArray(3); //the ages
      mTabDataArray[0].mDataArray[0].mString = new String("Thomas");
      mTabDataArray[0].mDataArray[1].mString = new String("Eric");
      mTabDataArray[0].mDataArray[2].mString = new String("Philippe");
      mTabDataArray[1].mDataArray[0].mInteger = 23 ;
      mTabDataArray[1].mDataArray[1].mInteger = 24 ;
      mTabDataArray[1].mDataArray[2].mInteger = 25 ;

      //Populate the database
      process.ArrayToSelection(mTabDataArray, mFieldTab);
    }
    catch (opException er){throw er;}

    return selection;
  }

}