I have created a dynamic view (to be used as a prompt) in our PeopleSoft Version 9 environment to pull back values based on what is getting returned from a business interlink. Since our Version 9 environment is not available yet, we need to apply something similar to our PeopleSoft Version 8 environment. When I tried to apply this same logic, it is saying that the SQLText is not a valid property of the field class. I was just wondering if there is something equivalent to this SQLText property in Version 8 or how I should go about doing something similar.

PeopleCode from Version 9:

      Evaluate %Component
      When = Component.FHIM_FH_INVOICE
         /*Logic to loop through the interlink*/
         &ROWSDoc = &ODOCRESULTDoc.GetDoc("ROWS");
         
         &ROWDoc = &ROWSDoc.GetDoc("ROW");
         &NumRows = &ROWSDoc.GetCount("ROW");
         &BU_LIST = "";
         
         For &i = 1 To &NumRows
            
            &NumCols = &ROWDoc.GetCount("COL");
            For &j = 1 To &NumCols
               
               &ret = &ROWDoc.GetValue("COL", &COL);
               
               /*Populate the &BU_LIST variable to be used with the Select Statement for the 
               dynamic view*/
               If None(&BU_LIST) Then
                  &BU_LIST = "'" | &COL | "'";
               Else
                  &BU_LIST = &BU_LIST | ", '" | &COL | "'";
               End-If;
               
            End-For;
            &ret = &ROWDoc.GetNextDoc();
         End-For;
         
         /*Build the Select Statement for the Dynamic view*/
         
         /*If there are no items in the queue, pull back no business units*/
         If None(&BU_LIST) Then
            &BU_LIST = "''";
         End-If;
         &BU_SELECT = "SELECT DISTINCT BUSINESS_UNIT FROM PS_FHIM_Q_SOURCE WHERE 
         BUSINESS_UNIT IN (" | &BU_LIST | ")";
         
         /*Assign the SQL for the Dynamic view*/
         GetRecord(Record.FHIM_INV_WRK).GetField(Field.BUSINESS_UNIT).SqlText = &BU_SELECT;
         Break;
      When-Other
         Break;
      End-Evaluate;