I set a limit in the subfile build.  If the subfile exceeds that limit then the user sees a message window suggesting a tighter filter, or that only the first x records will be displayed, or ... .

   dou sqlcode <> 0 or SFLNUM > 200;   // limit subfile to 10 screens:

As an aside, one of the consequences for me is being forced to think through the design a bit more.  Usually this results in better user-flow and easier new-user training. In other words, a better product.

On 11/25/2019 2:18 PM, Jon Paris wrote:
I tend to agree that 9,999 should be more than enough - but how to handle that in a user-friendly way is the issue. If you have offered them to display customers with a wildcard match on the name and they enter*a* on a high file ...

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.