Finding - Set 'Omit' in a script

[Tom Kennedy]

I am trying to keep the Status Area hidden from the user.

Is there a way to change 'Include' to 'Omit' in the hidden Status Area from a script?

[comment]

Omit Record.

[Tom Kennedy]

I have tried various script combinations where I have included the 'Omit Record' code without success. Can I have a little more guidance?

In addition, If I get the 'Omit' flag to come on, how do I get the 'Include' Flag to turn on later?

[RalphL]

There are 2 things to consider. 1, The Omit should be a new request at the end of the finds. 2, The status can be hidden but not locked.

[comment]

When you are in Find mode, the Omit Record script step TOGGLES the current find request between Omit and Include.

[Tom Kennedy]

Close, but no cigar.

I have set up 3 buttons:

Button1 Line1 - Enter Find Mode []

Button2 Line1 - Perform Find []

Button3 Line1 - Enter Find Mode []

Button3 Line2 - Omit Record

Lets say that I have 1,000 records total and that I first want to find 200 of them. And from that 200, I want to omit 10 resulting in a found set of 190.

If I click on Button1, enter find cirteria and then click on Button2: I get the correct number of records (200) in a found set.

If I then click on Button3 (which has the Omit Record code), enter find criteria and then click on Button2: The records are omitted from the total number of records not from the found set. That is, I get a found set of 990 instead of 190. Any ideas?

Thanks for all of your help.

[RalphL]

It is working like it should. You need to use the Constrain Found Set for button 4.

[comment]

I'm afraid your little test has nothing to do with your original question. You will end up with the same result if, instead of pressing Button 3, you enter Find mode and click the 'Omit" button manually.

You need to review how find requests work, and how Find works in general. Whenever you do Perform Find, you are searching the entire table - whether to omit or to include. The correct order of actions here would be:

Enter Find Mode

# enter criteria for 'include'

New Request

Omit Record

# enter criteria for 'omit'

Perform Find

Or:

Enter Find Mode

# enter criteria for 'include'

Perform Find

Enter Find Mode

Omit Record

# enter criteria for 'omit'

Constrain Found Set