Finding only 'some' records ??? huh

[ron G]

This is my report in 'show all' mode. Notice the last 2 records for Wellsfargo and the Expiration date range at the top. [color:red](FHUHA & FHUZZ)

After the I press the "FIND" button, I get the above. Notice that the last Wellsfargo option, [color:red]FHUZZ even though it is within the date range, is NOT listed???

This is the script that drives the FIND.

The above is the actual OPTIONTRANSACTIONS TABLE upon which the 'find' is performed.

[color:red]The puzzling part of this situation is that the FIND gets 'some' of the records but not others?:

Got any ideas?

[mr_vodka]

script?

[ron G]

The script is in the original posting. (It is the 2nd image from the bottom)

[Lee Smith]

It would appear that the globals are being set manually?

OR, you have old data in the global, therefore you would either be not getting any find, or a repeat of an older find.

I believe that I asked you in another thread of yours, Attached a copy of this beast.

If you did that, and basic of this script was in it, please point me to it. other wise, it would be simpler for you to attach a copy of your file, then to continue to post all of these screen shots.

Lee

Edited July 28, 2009 by Guest

[mfrapp]

Try

Enter Find Mode[]

Set Field ExpDate >= FindStartDate

Perform Find[]

Enter Find Mode[]

Set Field ExpDate <= FindEndDate

Constrain Found Set[]

and of course your global finds and expiration fields must be of type "Date"

[LaRetta]

There is no reason to perform two find requests instead of using the globals for date range search.

[David Jondreau]

Without the file it's hard to tell...but it could be a layout/sorting issue. Are you sure the scripted Sort[] matches the Show All sort? What's the actual "Found Count" of the set?

[mfrapp]

obviously the date range is not working, im just suggesting a alternative

[comment]

Obviously, if the range find is not working, the proper course would be to determine the cause of the failure.

[ron G]

The range find works ok.

The issue is:

This is my report in 'show all' mode. Notice the last 2 records for Wellsfargo and the Expiration date range at the top. (FHUHA & FHUZZ)

After the range find is initiated, ONLY FHUHA shows. :? Weird.