Omit record from a found set

[jfrick]

I'm trying to omit a record from a found set in ScriptMaker.

Enter Find Mode

Set Field["codefield","3"]

New Record/Request

Set Field["codefield","7"]

Perform Find

Go to Related Record[dumprecord]

Omit Record

Above doesn't work. I'm guessing "Go to Related Record" resets the found set.

I have a specific record, let's say UserID: 42 that I want to omit from this found set. How can I achieve this?

[Vaughan]

Enter Find Mode

Set Field["codefield","3"]

New Record/Request

Set Field["codefield","7"]

Perform Find

Loop

Exit Loop If { UserId = 42

Go to Record/Request [ next, exit after last ]

End Loop

Omit Record

This is a bare-bones script, it'd need a lot of error checking to be reliable in a production environment... like checking for find errors etc.

[jfrick]

Thanks Vanghan. That'll work.