Trying to understand something

[oilman]

Hi all

I do a search on three db for a four db. I have a field in the three db that I do a search on that capture the status(currentfoundcount) number. This is where I do not understand why one db will display the number of records in that db when "show all records" is chosen after the find is completed while the other two db displays the status of the find even after "show all records" is chosen.

The fields are defined as calculation.

example

s_count = Status(currentfoundcount)

I though maybe the db became corrupt but after running recovery on this db, the results are the same.

Any ideas.

Thanks in advance

Lionel

[-Queue-]

This is one of those 'gotcha's. Any calculation field involving a Status() function must be set to unindexed, with the 'Automatically turn indexing on if needed' checkbox deselected, or else the calc will not update.

[oilman]

Hi Queue

So the field should change when the "show all records" is chosen.

Lionel

[-Queue-]

Yes, it should update according to the change in the number of records being browsed. If you omit all records, it should show zero. If you Show All Records, it should equal the total. If you omit one record, it should show the total minus one. But it cannot update unless it is set as unstored.

[oilman]

Hi Quene

Thanks for the information and did what you said.

Lionel