Equinox Online Help - Language Reference - A to Z
PickRange, PickRecordRange |
|
|---|---|
| Applies to |       |
| Syntax | PickRange (ReturnfieldName ,[SearchExpression], IndexName [, LowerExpression, UpperExpression]) PickRecordRange (ReturnfieldName ,[SearchExpression], IndexName [, LowerExpression, UpperExpression], Field1Name [, Field2Name, Field3Name, Field4Name]) |
| Action | [Function] These functions compile a list of remote records from a given range. You pick one of the records and a specified field value is returned from it. |
| Scope | Usable anywhere. |
| Notes | These functions are almost identical to the Pick function, except that they include two extra (optional) arguments. You can use these arguments, LowerExpression and UpperExpression, to specify a range of records. Only records with values of IndexExpression between LowerExpression and UpperExpression (inclusive) are included. Any of the these three expressions may be MakeKey values. The use of the PickRange command with a child index only works from within the parent subtable. The SysReply system workarea is set, in the same way as for the Pick function. |
| Category | Pick lists |
| See Also | Pick_PickRecord, PickCaptions, PickColumnWidths, PickFields, PickList, PickListSelection, PickSelection, PickWrite_PickRecordWrite |
| Example | This example allows the user to choose from a list of parts beginning with the letter K. OrderPart = PickRange(part,,ptidx,"K","Kz") |