My application is a Membership application.

There is a field named: Membership::Mem_Can which holds a value of "Member" or "Candidate"

In the database there are 55 Members

In the database there are 8 Candidates

Of the 55 members, 2 are deceased. (The DOP field has a date in it)

I am trying to do a find all members who do NOT have a date in the DOP field. (They are no deceased)

There are 53 members who meet this criteria.

=====THE PROBLEM======

I write a script with these steps:

FIND Mem_Can="Member"

OMIT DOP<01/01/50

What results is a found set that shows 55 records.

I am using a script LOOP that goes through the found set and updates the STATUS of each MEMBER.

The last 2 records don't get processed because the found set finds 55.

But a variable, $$foundset shows 53?

(I also tried using CONSTRAIN FOUND SET and got the same result.

? ? ? ?

Thanks

Ron

OMIT DOP<01/01/50

This will only omit persons who died before 1950.

I found the answer.

Carefully following the debug trail through several subs, led me to a 'find' that screwed up my intended 'find'.

Mystery solved. User error .... again....

In order to find for an empty field use = in the field

RE: using '='

Thanks... I forgot that one and it is not documented in my FM books..