Hammer -

I've tried using the xResultSets as you suggested.  I'm making some progress, but i've run into a problem.  I'm trying to use the following programming:


#include "sbasic_include.sbas"

var vHandle as Int
var VNoOfRecords as Int
var vLoop as Int
var vRubber as string
var vLotNumber as string
var vExtension as string

vRubber = "EG-4501"


vHandle=@xResultSetSearch(@FN,"Mill Log!Mill Lot Numbers", SEARCH_MODE_AND, SEARCH_SYNTAX_QA, "!Material=vRubber..")

If(vHandle>-1)

{

     vNoOfRecords = @XResultSetTotal(vHandle)

writeLN("NoOfRecords: "+vNoOfRecords)

     For vLoop= 1 to vNoOfRecords
           xResultSetCurrentPosition(vHandle,vLoop)

           vRubber = @xResultSetValue(vHandle,"Material")
           vLotNumber = @xResultSetValue(vHandle,"LotNumber")
           vExtension= @xResultSetValue(vHandle,"Extension")

                 WriteLn(vRubber + "---" + vLotNumber+"-"+vExtension)
           Next

           xResultSetClose(vHandle)
}

Eventurally, i will replace the vRubber variable described above with data from a form element.  However, when i try to use a variable in the vHandle statement I don't get any hits in the search.  If I use "" or "EG.." I get a list but not the list I want.

I'm looking for material numbers EG-4501, but if I use either of the two above, I get every material (when i use "") or every EG material (when I use "EG..").

Is there something about using variables that I'm missing?

I'm trying to look through the file "Mill Lot Numbers" in the Materials element for all those that match the variable vRubber.  In this case, I've assigned that vRubber number "EG-4501".  There a five records in Mill Lot Numbers that have EG-4501 in the Materials element, so I'm trying to list them.

I eventually want to select all the Materials that match vRubber AND match a certain LotNumber, which will be a variable vLotNumber.

Am I heading in the right direction?