Omit Record Issues

[nelliott]

I have a script which is designed to omit records from a search that do not meet a certain criteria (see below):

Go to Record/Request/Page[First]

Loop

If ["Count < Max Count1 or

Count1 < Max Count2 or

Count2 < Max Count3 or

Count3 < Max Count4 or

Count4 < Max Count5"]

Omit Record

End If

Go to Record/Request/Page[Exit after last, Next]

End Loop

where the Count fields are calculation fields counting how many times a certain word appears in a field and the Max Count fields are user-inserted text fields

When I run the script it only Omits some of the records and I have to run it a number of times before all the required records are omitted.

Any ideas why I am needing to run the script multiple times to omit the records

Cheers

Nick

[djgogi]

The script should be

Go to Record/Request/Page[First]

Loop

If ["Count < Max Count1 or

Count1 < Max Count2 or

Count2 < Max Count3 or

Count3 < Max Count4 or

Count4 < Max Count5"]

Omit Record

else

Go to Record/Request/Page[Exit after last, Next]

End If

End Loop

Dj

[nelliott]

Of course! Thanks a lot Dj

[SteveB]

Dj: Isn't there are problem with your construction if you are on the last record, and it gets omitted? Will you just wind up looping?

Steve

[BobWeaver]

Steve: I think this was a bug that was in 5.0 but seems to have been fixed in 5.5 and later. Imagine that. a fixed bug!

BTW, I generally avoid the skipped record problem, when omitting in a loop, by starting on the last record and then using the Go to Record [previous, exit after first] construct.