I have a file that includes a series of similar part numbers.  For example, 1234AA, 1234AB, 1234AA1, 1234AA3, 1234AC1, etc.  From another file, I want to be able to select all the items of a certain type based on the first six characters. 

Using my list above, I want to select 1234AA, 1234AA1 and 1234AA3.

I then want to place all the information for each of these part numbers into an element of the file.  I'd like the information to be in a list format so it is easy to read.

I know how to select one item that exactly matches one record.  How would I program it to select multiple, similar items?

I understand what ".." does.  I'm trying to use @xResultSetSearch to create a list that I can enter into a multi-line element in my file.  I've developed the programming below, so far.  I've not used this command much, so I'm a little hazy on the details.

I believe the programming below should create the retrieve spec "1234AA.." and then go to the file Overruns.  It will look for all records where the PartNo is equal to "1234AA..".

When I run the program, it appears to go looking into Overruns because vHandle>-1.  But, it doesn't select any records as vNoOfRecords=0.

Any suggestions would be appreciated!



#include "sbasic_include.sbas"

var vHandle as Int
var VNoOfRecords as Int
var vLoop as Int
var vPartNo as string
var vDCNo as string
var vLocation as string
var vStatus as string
var vDate as string
var vQuantity as int
var vTemp1 as int

vDCNo = @left(DiaCom P\N,6)

writeln(vDCNo)

vHandle=@xResultSetSearch(@FN,"Overrun", SEARCH_MODE_AND,SEARCH_SYNTAX_QA, "!PartNo = "+vDCNo+"..")

WRITELN(VHANDLE)

If(vHandle>-1)

{

writeLN("Made it!")

     vNoOfRecords = @XResultSetTotal(vHandle)

writeln(vNoOfRecords)

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

           vPartNo = @xResultSetValue(vHandle,"PartNo")

           vTemp1=1
           Next

           xResultSetClose(vHandle)
}

if vTemp1<1
{
     @MSGBOX("IT DIDN'T WORK!","","")
}

You're getting partial success because the XResultSet is opening, but it's not finding any matches. The space after the field name is being consider part of the field name. Consequently, Sesame is trying to find a field named "PartNo ", with a space at the end.

It would probably work with a space after the equal sign, but it's just easier to avoid them altogether in this particular parameter.