I want to create say 200 duplicate records at once, with consecutive serial numbers. I'm ok with the serial no. side of it but not the script to limit the creation of records to a set number. Appreciate any assistance.

If i understand you:

Loop

Duplicate record request

Endloop

Press Esc when you want to stop creating.

aaa has suggested one way, I'm not sure I can stop a loop in a timely manner with escape.

I would create a number field "Counter"

and use a script like:

Set Field [ Counter; 0 ]

Loop

Duplicate Record/Request

Set Field [ Counter; Counter + 1 ]

Exit Loop If [ Counter = 200 ]

End Loop

HTH

Lee

Edited July 22, 200520 yr by Guest
Sorry I misread the script

Loop

Duplicate record request

Endloop

Press Esc when you want to stop creating.

Hee, hee! Thanks for the laugh, aaa!

Another option

Freeze Window

Show All Records

Omit Record

Show Omitted

Loop

Exit Loop If [Get(FoundCount) = 1]

Go to Record/Request/Page [Last]

Omit Record

End Loop

Loop

Duplicate Record/Request

Exit Loop If [Get(RecordNumber) = 201]

End Loop

Edited July 23, 200520 yr by Guest
Added missing End Loop step

Hi JT

I understand what you aiming at but, if you take a closer look at the steps ...will you ask yourself: When will you ever reach the inner loop???

--sd

Thanks, Soren. I had inadvertantly omitted the End Loop step for the first loop.

I thought S

In a multi-user environment,

Show All Records

Omit Record

Show Omitted

could easily show 2 or more records; the more people concurrently using the solution, the more likely it will occur. If 2 people create/commit a new record in between the time that Omit Record and Show Omitted steps are performed, then Show Omitted could display 3 records. It is a rare occurrence, but if used in a multi-user solution, it is safer to use the loop or a GTRR self-related ID step when it is crucial to have a single record on which to operate.