Duplicating Records

[XBOT]

In A Script I Import Records To A New Table. Then For Purposes Of Preparing Duplicate Parts Labels, After Going To The First Record, I Start A Loop With Duplicate Record , Go To Next Record And Continue To End Of Table. It Keeps Repeating The First Record , Does Not Move To The Next Record. What Am I Missing?

[AHunter3]

You have to omit the record you end up on becuase it IS the duplicate of the record you duplicated, not the original record you made that duplicate FROM.

 

I usually do it like this:

 

Set variable [$RecordNum, 1]

Loop

..Go to Record [by calculation $RecordNum]

..Duplicate Record/Request

..Omit Record/Request

.. Set Variable [$RecordNum, $RecordNum + 1]

.. Exit Loop If [GetAsNumber ($RecordNum) > Get(FoundCount)]

End Loop

[XBOT]

Thank You

 

I Have Just Recently Started To Get Into Scripting. This Program Is Very Different Than Something I Used To Write In Years Ago Called Vp Info.

[AHunter3]

You Will Probably Get More Useful Responses From More People If You Do Not Capitalize Each Word. It's Hard To Read.

 

(better than ALL CAPS though)