eScript Framework - Query return Array

In my post introducing my eScript Framework, I glossed over the functional content of the functions I included so let me go into some more detail before proceeding. The last function in the declaration was called QueryExprArrayReturn. This function will execute a query against the business component whose string name is passed to the function using a complete expression also passed. The last parameter is an array of fields whose values will be returned, via an associative array.

QueryExprArrayReturn : function( sBO, sBC, sExpr, aFields) {
// Use : Frame.QueryExprArrayReturn (sBO : string nsme of Business
Object,
// sBC : string nsme of Business Component,
// sExpr : search expression to be applied,
// aFields : array of fields to be returned)
// Returns : string replacing fields and parameters from the lookup BC and/or property set
  var aFnd, bFound, iRecord, sField;
  var aValues = new Array();
  var rePattern = /(?<=\[)[^[]*(?=\])/g; 
  with (TheApp.GetBusObject(sBO).GetBusComp(sBC)) { 
    while ((aFnd = rePattern.exec(sExpr)) != null) ActivateField(aFnd[0]); 
    for (var c=0; c < aFields.length; c++) ActivateField(aFields[c]); 
    ClearToQuery(); 
    SetViewMode(AllView); 
    SetSearchExpr(sExpr); 
    ExecuteQuery(ForwardOnly); 
    if (FirstRecord()) { 
      iRecord = 0; 
      for (var i=0; i < aFields.length; i++) { 
        aValues[aFields[i]] = new Array(); 
        aValues[aFields[i]][iRecord] = GetFieldValue(aFields[i]); 
      } 
      while (NextRecord()) { 
        iRecord++; 
        for (var i=0; i < aFields.length; i++) { 
          aValues[aFields[i]][iRecord] = GetFieldValue(aFields[i]); 
        } 
      } 
    } 
    return(aValues) 
  } 

What is occurring here is pretty straightforward:

1. Instantiate a BC using the passed BO/BC strings
2. Activate any fields used in the Search Expression
3. Activate the fields needing to be returned
4. Query using the passed search expression
5. If at least one record is found, create an associtive array of field values where the first index is the field name and the second index is the record number
6. Continue populating this array for each record found

Probably the most interesting aspect of this query is the use of a regular expression search of the passed in expression to activate and BC fields present there by identifying them in enclosing square brackets [].