Re: SQL Problem

Hi Sharon,

I know you have your answer, but I wanted to offer another alternative....

How big is your dataset? If it is not too large, you could load the dataset to an data structure array in one fetch. Then any changes of your sort field would simply require a sort of the array by the desired subfield and refill the subfile. No database access needed.

Good Luck,
David



--------------------------------------------------
From: "Wintermute, Sharon" <Sharon.Wintermute@xxxxxxxxxxxxxxxx>
Sent: Monday, October 19, 2009 12:26 PM
To: "RPG programming on the IBM i / System i" <rpg400-l@xxxxxxxxxxxx>
Subject: SQL Problem

I have a new situation I have not encountered before. I have a work with
display that can have up to 13 different position to values with 13
different sorts. Seems like the perfect candidate for sql.



All my other sql routines use a standard prepare, declare, open, fetch
close with one cursor. I thought if I closed the cursor I might be able
to re-open it with a different prepare but no luck. It doesn't allow
that. (Figures).



Basically I can use 1 to 13 different position-to fields and one sort at
a time.



So how do I go about this?





Sharon Wintermute



--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.