Re: Best approach for Embedded SQL SELECT in V7R1

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

On 2012-11-06, at 11:08 AM, rpg400-l-request@xxxxxxxxxxxx wrote:

> One nice thing about using SQL to build subfiles is that you can do some
> fancy alternate sorting by manipulating the ORDER BY clause. Done right,
> this can give the user the ability to sort ascending or descending by
> any column in the subfile.  

Just a comment on this.  I always find that this method confuses users. When you are looking at data and you request a sort on the subfile, the data you expect to get back is a reordered version of what you just saw. But with this approach the data being retrieved may not match due to updates in the interval.  Not uncommon in a system with a lot of transactions. I've seen users puzzle over a screen for a long time trying to find an item they thought they'd seen in a different sequence.

I load most subfiles into an array when they fit (and a user space when they don't) and that way I can sort the same data over and over. User has an option to refresh when they want.

Just a thought.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com