Re: Running Total- @1?

2004-04-02 Thread Allen Egerton
On Fri, 2 Apr 2004 14:54:14 -0800 , you wrote: LIST CUST EVAL @1+1 CUST.NAME Well OK, I'll 'fess up to being clueless... what is @1? Why does this work? (running UV 9.6.1.3). What other @ variables are left out of my docs? The most common use I've found for @1, @2, etc are within very complex

RE: Running total

2004-04-01 Thread Garth Joubert
Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total Is

RE: Running total

2004-04-01 Thread Roger Glenfield
] Behalf Of Garth Joubert Sent: Thursday, April 01, 2004 5:19 PM To: U2 Users Discussion List Subject: RE: Running total Hi Ya, Quick way is to try: LIST CUST EVAL @1+1 CUST.NAME (This might be dependant on Release Level) Wish you luck. -Original Message- From

Re: Running total

2004-04-01 Thread John Kent
Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM Subject: RE: Running total Hi Ya, Quick way is to try: LIST

RE: Running total

2004-04-01 Thread Garth Joubert
[mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 2:07 p.m. To: U2 Users Discussion List Subject: Re: Running total Do you have anything for a multivalue counter with either an EVAL or ITYPE jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List

Re: Running total

2004-04-01 Thread Allen Egerton
On Thu, 1 Apr 2004 17:08:02 -0500, you wrote: Is there a way in UniQuery to create a virtual attribute that will print a running total of the number of items listed? For example: LIST CUST RUNNING_TOTAL CUST.NAME ID RunningCustomer Total Name... 111

RE: Running total

2004-04-01 Thread Mitchell, Stewart
Can you post the pick style dict, please. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12:59 To: U2 Users Discussion List Subject: Re: Running total Garth Thanks, but i was after something like an itemised list for each mv entry

Re: Running total

2004-04-01 Thread John Kent
- From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 1:02 PM Subject: RE: Running total Can you post the pick style dict, please. -Original Message- From: John Kent [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 12

Re: Running total

2004-04-01 Thread John Kent
Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 2:04 PM Subject: RE: Running total Hi John, Faulding is good, we are owned by Mayne now. Just as per Ken's example here is the UV equvilant Top. : 0001: I

Re: Running total

2004-04-01 Thread John Kent
- Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 2:34 PM Subject: RE: Running total John, I got the same result as you in HS.SALES However, this worked in HS.SALES against the customer file field 11

RE: Running total

2004-04-01 Thread Mitchell, Stewart
: Re: Running total Stewart, thanks, i agree with the D version but do not get the I type to work as you suggest can you confirm LIST CUSTOMER SMM.CNT SMM.ICNT displays the same data? I would really like the itype work so i can reuse a static field to get an incrementing date against each mv

Re: Running total

2004-04-01 Thread John Kent
Stewart, that will do nicely I can go home now jak - Original Message - From: Mitchell, Stewart [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, April 02, 2004 3:19 PM Subject: RE: Running total John, Try this for your itype SMM.CNT 0001 I