AnsweredAssumed Answered

Need Script to Loop thru  a table and check each field

Question asked by MichaelHemberger1003 on May 23, 2012
Latest reply on May 24, 2012 by MichaelHemberger1003

Title

Need Script to Loop thru  a table and check each field

Post

Can anyone help me script the following:

Loop thru a table with all fields in table on one layout and store result in a different table

Starting with the first field of the first record in the main looping table:

 

(1) Check the field(numeric) for a value greater than 0

If the field value is greater than 0

Create a new record in a different table

copy the field value that was greater than zero into the new record in the different table

copy the fields name also into the new record in the different table

Now get the next field (looping table) after this one and copy it's value also into the new record.

end if

 

Check to see if t there are no more fields in the first record of the looping table.

If there are more fields then loop back to (1)

If there ar NO more fields then get then next record, unless were out of records in the looping table

If there are more records then get the next record and start looping the all the fields.

Outcomes