I do it all the time.
Select THIS, THAT, OTHER, wdata(rand(136912)) name(sort) from SOMEFILE
order by sort
CassidyA@xxxxxxxxxx 04/21/2008 3:19:10 PM >>>
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.
midrange.com
