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



I thought about that during the design, but the data changes extremely
quickly so by loading into the dataset, I lose the updates and deletes
that occur. We add/change/delete records from this file quickly.


Sharon Wintermute


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave
Sent: Monday, October 19, 2009 10:12 PM
To: RPG programming on the IBM i / System i
Subject: 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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.