Deleting Found Records

["... you mean these fans?"]

Hi,

I have solution on a network server.

After some forum suggestions we started finding and navigate our layouts under a "zero" record condition.  Only showing records that are required when required.

When I am in a condition within our scripts to "Delete" the found set, I have noticed that instead of showing "Zero" records after the script deletes ... FileMaker dumps all the records that were not in the found set, which can be significant in some tables ...  ??  So I would see 23 / 5000 Found ( Sorted ), then the script deletes, to 4977 Total ( Unsorted ).

So what is going on ?? any insight, can I prevent FileMaker from doing this ?

Thank you.

[comment]

You could delete them one-by-one in a loop. I can't think of any other method at the moment. 

[LaRetta]

One possibility ...

1. Go to your layout with zero records
2. Perform your find
3. Open a new window
4. Perform Delete All Records
5. Close your window

This should leave you with your 0 record state.  Of course it still fetches those needless records but at least you've back to 0.  I suppose you could instead Show Omitted so I doubt this will help.

 

Edited July 14, 2017 by LaRetta