RE: Help Systems/ASC/Sequel--Hiding a sort column

["Paul Nelson" <nelsonp@xxxxxxxxxxxxx>]

Um, I did it as a test just before responding to you. What version are you
running? I'm running 8.7.088

See this:

SELECT   WDATA(eqco) NAME(co), eqid, easscl, eaddnl, edescr   
FROM     eam900f/eeqmst                                       
ORDER BY co, edescr                                           

Paul Nelson
Office 512-392-2577
Cell 708-670-6978
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Cassidy, Alan
Sent: Monday, April 21, 2008 5:19 PM
To: Midrange Systems Technical Discussion
Subject: RE: Help Systems/ASC/Sequel--Hiding a sort column

Yes I did guys, and guess what, it does not allow a hidden column to be
included in the ORDER BY list.

I don't think there's a way around it, but what I did is that I just ran
EXECUTE  OUTPUT(WORKFILE) in the proper order, and then did another view
over that one without any ORDER BY clause.

If you find something less "kludgey" let me know... 

Thanks
--Alan


 

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Nelson
Sent: Monday, April 21, 2008 1:45 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Help Systems/ASC/Sequel--Hiding a sort column

Have you tried WDATA?

Paul Nelson
Office 512-392-2577
Cell 708-670-6978
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Cassidy, Alan
Sent: Monday, April 21, 2008 12:40 PM
To: Midrange Systems Technical Discussion
Subject: Help Systems/ASC/Sequel--Hiding a sort column

For those who use Help System's "Sequel" product --Paul?--refresh me on
the way to hide a column that is included in the Sort list?

They're working on some issue with the system server jobs that the
ViewPoint uses, so at this time a green screen answer would be nice.

--Alan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.