CAS 6

---

RecordSet.Select method extended to accept multiple selection statements

The RecordSet.Select method now has the option to accept multiple selection statements as the first argument. The second argument is extended to also use a StringList.

Syntax

RecordSet.Select (Selection Fields)

Selection

Type	Description
CharString	Single selection statement
StringList	Multiple selection statements.
RecordSet	Table of selection statements. Statements must be in a field called "EXP". Optional Boolean "ON" column defines statements to include and omit. See notes.

Example

 cs←CasSession.GetCurrentFile'' 
 item←cs.GetItem'\CAS Items\Table Report\Wide Sample' 
 sc←CasItems.GetLocalSelectionCriteriaSelect item 
 rs2←cs.Select'' '' 
 rs2←cs.Select(CharString.New'')'' 
 rs2←cs.Select(CharString.New'STATE in "PA,VA"')'' 
 rs2←cs.Select sc'' 
 rs2←cs.Select'first 1000' '' 
 rs2←cs.Select(StringList.New'')'' 
 sl←StringList.New'' 
 sl.Add CharString.New 'first 100' 
 sl.Add CharString.New 'PROPTYPE eq "A"' 
 rs2←cs.Select sl'' 

Notes

• Multiple statements are combined using an "and" operation.
• Empty Selection input will return all rows
• RecordSet input containing an "ON" field will only include statements where ON = 1.
• Empty Field CharString input will include all fields.
• Empty Field StringList input will include all fields.