Hello,

I am trying to set the "Omit Flag" in Find Mode via script, after
seeting a few fields the same way, can't seem to find an easy
workaround. This is what I am doing:

Open new window.
Enter Find Mode
Find a set of Records
Omit a set of Records

Some of my criteria comes from variables/global fields, which cannot
be used in the "Perform Find" criteria.

I would appreciate some hints,

Thanks, TL

On Apr 16, 8:23 pm, TL <tla... (AT) yahoo (DOT) com> wrote:
To start you'll need the following script steps

enter find mode
set field -- from variable
....
....
perform find

---
Once you've got a handle on that (you'll need to check/uncheck some of
the script step options to make it work) building complex multiple
request scripted finds is easy:

Next check the help on the following script steps with an eye to what
they do while in 'find mode':

new record/request
duplicate record/request
omit record

-cheers,
Dave

In article <1176780232.218910.26220 (AT) d57g2000hsg (DOT) googlegroups.com>, TL
<tlassu (AT) yahoo (DOT) com> wrote:

I don't know about variables, but Global fields CAN be used in Find
mode, that's one of the situations where they come in VERY handy. You
can easily create a script that copies the value from a Global field
into a normal field simply using Set Field. This means you can fake the
Find by getting the user to type their requirements into Global fields
and then script the Find yourself.

You can turn the Omit checkbox on and off using the Omit Record command
- in Browse Mode it moves the current record to the "Non-found Set",
but in Find mode it toggles the Omit checkbox.

Combining both of these, your script should probably be something like:

Enter Find Mode []
Set Field [FindField, gFindCriteria]
Omit Record
Perform Find []

which will Omit all the records where FindField matches the data in the
Global field gFindCriteria ... or in other words, finds all the records
where FindField doesn't match the data in gFindCriteria.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)