locked
Limiting an Array Q. RRS feed

  • Question

  • Can you limit the number of records that an array gathers?
    Tuesday, January 21, 2014 7:36 PM

Answers

  • GATHER FROM ArrayName | MEMVAR | NAME ObjectName
       [FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton]
       [MEMO]
    Tuesday, January 21, 2014 7:51 PM
  • Quickbuzz,

     

    My first answer was regarding fields.

    SCATTER..GATHER is done one record at a time, if you want to limit the number of records you would have to create a filter

    If my answers do not satisfy your question, please clarify what you are looking.


    Wednesday, January 22, 2014 12:36 AM

All replies

  • Can you provide a little more information please?  How are you creating the array and how to you want to limit the number of records?
    Tuesday, January 21, 2014 7:43 PM
  • GATHER FROM ArrayName | MEMVAR | NAME ObjectName
       [FIELDS FieldList | FIELDS LIKE Skeleton | FIELDS EXCEPT Skeleton]
       [MEMO]
    Tuesday, January 21, 2014 7:51 PM
  • Quickbuzz,

     

    My first answer was regarding fields.

    SCATTER..GATHER is done one record at a time, if you want to limit the number of records you would have to create a filter

    If my answers do not satisfy your question, please clarify what you are looking.


    Wednesday, January 22, 2014 12:36 AM
  • I think you want to copy limited number of records from dbf to an array. If yes, you have to use COPY TO ARRAY command with scope.

    Scope

    Specifies a range of records copied to the array. Only the records within the range are copied. The scope clauses are: ALL, NEXTnRecords, RECORDnRecordNumber, and REST. For more information on scope clauses, see the Scope Clauses online topic.

    Thursday, January 23, 2014 7:33 AM
    Answerer