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.