Re: Subfile question - Position To functionality

In the end, I did this with an SQLRPGLE program, mostly because SQL has such a fantastic wildcard search capability. This allows the users to search by unique characters - both "ABC" and "Toy" will get "The ABC Toy Company". Plus, with SQL it can be case-insensitive. I would add this: this is more than position-to. Its selecting only desired records.

This is a link: http://www.martinvt.com/SQL_-simple-/SQL_Name_Editor/SQL_Names_Index/sql_names_index.html

This is the wildcard search (very simple, very fast):

****

****

wSRCHCOMP = %trim(SRCHCOMP) + '%'
exec sql declare C1 cursor for // define data to be retrieved
select *
from NAMESP
where NACOMPANY like :wSRCHCOMP
order by NACOMPANY, NALAST;
...
dow Sqlcode = 0 and SF1NUM < cLimitSFL; // Table read loop
select;
when wCursor = 'C1';
exec sql fetch C1 into :RecordDS;
...****
****

disclaimer: I am new with SQL. There probably are better SQL solutions, but this worked for me.

****



On 12/14/2016 9:18 AM, Bill Howie wrote:

Hello all,

Question for the group. I have the need to add "position to" functionality
to a subfile program. In this scenario, my subfile has one field which is
a bin location in a warehouse. The one field could look something like
"OVER-1A". I want the user to be able to key in just the letter "O" in a
field on the subfile screen and have the subfile display starting with the
records that begin with "O" and going from there. Is it just as simple as
doing a SETLL with the "O" as the key and it will read the records from
there on or is there more to it than that? Any info is as always
appreciated. Thanks!

Bill