RE: READE on a file selected by user

Here, here. I admit that I usually forget about this (using embedded SQL).
But I recall one inquiry a few years back where everybody and their second
cousins wanted different selections and sequences. I wound up writing a
selector panel where they could put in just about anything they wanted
(well, within reason, as defined by me) and sort (order by) whatever.
Building the SQL wasn't too bad.

Jerry C. Adams
IBM i Programmer/Analyst
I found a delivery in my flaw. -Don Quisenberry
--
A&K Wholesale
Murfreesboro, TN
615-867-5070


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Helge Bichel
Sent: Thursday, February 24, 2011 6:45 AM
To: 'RPG programming on the IBM i / System i'
Subject: RE: READE on a file selected by user

Hi David.

It's better and much more flexible using SQL for this task.

I know starting with dynamic SQL constructing the SQL with Select, Order By
etc.
and implementing the processing of Declare, Open, Fetch etc. can be a
challenge,
but done once I believe you would never go back using various SETLL, READE
processing.

Brgds
Helge


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of David FOXWELL
Sent: Thursday, February 24, 2011 1:01 PM
To: RPG programming on the IBM i / System i
Subject: READE on a file selected by user

Hi,

I'm sure someone must have already run into this problem :

User types in search criteria.

Program performs
SETLL searchFile
DOU %eof (searchFile)
READE(searchFile)

etc etc and loads a subfile with the results.


A new search field is added and a different searchFile must be used,
depending upon the search criteria used by the user.

So I could do

if searchType1
SETLL searchFile1
else
SETLL searchFile2

etc,

Very messy modified code!

I could copy and paste the original code and execute one or the other ( lots
of duplicate code)
I could use an SQL cursor. In this case I would have a lot more
modifications to make.

Any tips would be greatly appreciated.