1 2 Previous Next 17 Replies Latest reply on May 5, 2014 12:59 AM by user22423

    Is there a max of Values in a Value List?


      I store a huge amount of values in a valuelist and I wanted to know if the amount of values is limited?


      I use the following script to transpose data from table A to Table B based upon a query. The source table delivers a value in a specified Field. The target table becoms a copy of the source table but transposed to fields in a new record.


      The result of the query can be thousands of records.. so a variable must be able to keep thousands of values. The value itself is just one digit.


      Go to [Layout A]

      Perform Find [Restore]


      Set Variable ( $IDList ; List ( $IDList ; TableA:SourceField )

      Go to Record [ Next ; Exit after last ]

      End Loop


      Go to [Layout B]


      Exit Loop if [ Let ( $i = $i + 1 ; $i > ValueCount ( $IDList ) ) ]

      New Record/Request

      Set Field [ TableB::TargetField ; GetValue ( $IDList ; $i ) ]

      End Loop




        1 2 Previous Next