× 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.


  1.  Home
  2. RPG400-L
  3. July 2005

SQL Position-To with scroll-backwards capability

Searched the archives, but didn't find an answer...  The question:

How does one effect a "Position-To" in SQL?  SQL is required for this
effort (I think) because the user will get to specify on the fly the
values for which they are searching (for example, FIRSTNAME like
'Dan%').  Now, there might be 10,000 records that meet this criteria,
and the user wants the ability to position to 'Dann' BUT STILL HAVE
THE ABILITY TO PAGE UP (scroll backwards).  BTW FWIW, FIRSTNAME in
this example is a primary key field in an existing logical.

The requirement for dynamic wildcard searches indicates the need for using SQL.

TIA,
Dan

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-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.