× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



in my opinion:

We can take our lead from the Internet.  We ask for a Google search on, say, "RPG subfiles" and we get "About 25,100 results (0.41 seconds) "  with a panel of 12 to 20 responses and paging for what looks like maybe, 10 more pages.

The key appears to me to be the search bar; we use position-to and the rest of the world uses a "like" filter.

Using that paradigm. SQL, and a human-scale subfile limit of something like 15 to 30 screens (180  to 350 records) I get:

1. user-reinforcing search process,
2. a fast response,
3. a modern interface,
4. and, with a scroll bar, an entirely mousable subfile that pages,
inches, and leaps.

Here is an example:

http://www.martinvt.com/SQL_-simple-/SQL_Filtered_Subfile/sql_filtered_subfile.html

Here is the "like" part:

**

SRCH1X95 = 'Select by: "%" is wildcard (Smi, %ith, %mit, or %sm%h '
+ 'all get "Smith"). Case insensitive.)';
exec sql declare C1 cursor for // define data to be retrieved
select *
from COMPANYP
where COMPANY like :wSRCHCOMP
order by COMPANY, LAST;

**


On 4/4/2020 3:34 AM, techie21 IT wrote:
Hi,

Is single page subfile best subfile to avoid limit of number of records to
be displayed?

Thanks

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

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

This mailing list archive is Copyright 1997-2024 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.