Sorry-I'm not familiar with @USER0 Also this is thru a web interface so the user running the code in unidata isn't the same as the person running the web interface.
Jeff Butera Sent from my iPhone On Dec 23, 2010, at 11:48 AM, Shawn Hayes <go_mnviki...@yahoo.com> wrote: > I don't know if I completely understand the issue here... > > I have created dynamic sorts using @USER0 values. By LOCATEing the user in > XEM.PERSON, use that position to set the @USER0 value to the correct > XEM.VALUE. > Then use @USER0 value for the purpose of sorting the file.... > > Am I understanding your question? > > 'We act as though comfort and luxury were the chief requirements of life, > when > all that we need to make us happy is something to be enthusiastic about.' > > > > ----- Original Message ---- > From: Jeffrey Butera <jbut...@hampshire.edu> > To: U2 Users List <u2-users@listserver.u2ug.org> > Sent: Wed, December 22, 2010 9:06:54 PM > Subject: [U2] Need help with MV assoc/I-desc > > I need insight from the U2 faithful. This is Unidata 7, if that affects the > answer... > > I have a file which has 2 associated fields, such as: > > XEM.PERSON = 1737292:@VM:1818182:@VM:9187311 > XEM.VALUE = 23:@VM:14:@VM:99 > > What I'd like is a field which sorts by XEM.VALUE for the associated person > querying the records. That is, if person 1737292 is selecting records it > would > use 23 for purposes of sorting this record. If 1818182 is selecting, it > would > use 14 for sorting. > > I've done plenty of i-descriptors both with and without subroutines, but I > don't > have insight as to any method of allowing the query to know who's running it. > > I've dreamed about WHEN...ASD but Unidata only allow this in a LIST > statement > and it doesn't really do what I need, even if it were allowed in a SELECT. > > I need the data stored as listed above, but I am open to using a database > trigger to store this in some alternative form that makes the query easier to > deal with - but I can't think of how this might be accomplished. > > Any insight is appreciated. > > -- Jeff Butera, Ph.D. > Manager of ERP Systems > Hampshire College > jbut...@hampshire.edu > 413-559-5556 > > "Dad, one [dollar bills] are good but tens are way better." > Catherine Butera > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
