Duplicate all found records???

[ibiubu]

Is there a way to have a script that would duplicate all the records in a current found set?

So if I have 50 records in my database, perorm a find, now have 5 records in my found set, then I want to run a script that would duplicate just those 5 records in the found set.

Larry

[rdhaden]

Off the top of my head, this would do it:

Go to Record/Request/Page [Last]

Loop

Duplicate Record/Request

Omit Record

Omit Record

Exit Loop If [Get ( FoundCount ) = 0]

End Loop

[ibiubu]

Thanks. That seems to work. One last question. Is there a way to add one more step. After the records are duplicated, or during the duplication process, I would like to change the value of one single field in each record. I would like to do this by pasting the contents of the clipboard into the field of each duplicated record.

I tried:

Go to Record/Request/Page [Last]

Loop

Duplicate Record/Request

Paste[select:Questions::recordID]

Omit Record

Omit Record

Exit Loop If [Get ( FoundCount ) = 0]

End Loop

But that makes the whole script invalid...the found records did not even duplicate.

Any thoughts?

Larry

[rdhaden]

Sounds like it should work, unless the record ID field is not on the current layout, the layout is not in the context of Questions, the field is not modifiable, the field is not enterable on that layout, or the field is not of the same data type (text, number, etc.) as the data you're pasting.

If I had to guess, I'd bet that a field called recordID is auto-enter and does not allow user to modify.