Loop Script

[Mickdn]

Found this script in FM Help and I'm trying to implement it into my DB.

In the following example, you create a script to clear the contents of a field with five repetitions

count=1

Loop

Clear [select;FileName::FieldName[count]

count=count+1

Exit Loop If [FileName::count=5]

End Loop

What is [count] at the end of the Clear script?

What goes in here, the word count, the value 1? And how do I get it in there, does it go in the Repetitions box?

Also count=count+1, there is no script step for count that I can find, I found it in the Calculation box, but how do I get it into a script step?

Yes, I know you all hate Repeating fields, and I should be using Relationships and Portals, but this is a simple 1 layout design, with no extra relationships or tables. I just want to be able to clear the repeating fields with 1 script.

Many Thanks

[The Shadow]

Here's an example showing the script, and its use on a button to clear repetitions.

clearReps.fp7.zip

[Søren Dyhr]

Steer clear of repeaters, with your skill level is it called:

Go To Related Record[Found Set]

Delete All Record[No Dialog]

--sd

[David Jondreau]

It's never too early to learn to error trap.

[Søren Dyhr]

I know you all hate Repeating fields

I do not hate repeating fields, only the abuse of them deliberately violating relational concepts!

--sd