Omit records in find script

[Cyberskills]

How can i omit records in a found set in a script?

Allow User Abort (off)

Set Error Capture (on)

Enter Browse Mode()

Go to Layout inputform

Enter Find Mode ()

Set Field (City, "Brussels")

Perform Find()

--- i like to omit all the records with City="brussels"

If(Status(CurrentError) = 401)

Show Message ("No records were found", OK)

Show All Records

Go to Layout (original layout)

End If

[LiveOak]

Toggle Status Area (show) -- must have status area showing

Enter Find Mode()

Set Field (City, "Brussels")

Omit

Perform Find()

-bd

[Rigsby]

This is the second time I’ve seen you answer this question LiveOak. The only thing that puzzles me is that you always say that the status area must be showing! I’ve tried this out and the Omit works for me even if the Status Area is hidden! Strange. I can’t explain this at all!

Rigsby

[RussBaker]

The status area can be either hidden or showing for the Omit script step to work in the Omit-Find context - but it CANNOT be locked. If you check the Locked box in the script step, then Omit won't work

Russ