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

Okay guys, I was doing all that, but when I tried again on your say-so I
saw the REAL problem. It's called "programmer error". :=)

I had neglected to include it in the GROUP BY clause! Next time I'll
read the error message more carefully...

--Alan

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

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.

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