Re: Regarding significance of subfiles

[Booth Martin <booth@xxxxxxxxxxxx>]

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