Re: [U2] Running total

2013-07-04 Thread Charles Stevenson
...@yahoo.com Subject: Re: [U2] Running total Can anyone explain this situation better. I've only ever used the @ to simplify a few I-descriptors. I have a dict item SIZE that is just the LEN(@RECORD) So in this thread we've seen two EVAL solutions to a running total LIST VOC SIZE EVAL @1+SIZE LIST

Re: [U2] Running total

2013-07-04 Thread Martin Phillips
From Martin's response, I'm guessing not for QM, either. In QM, the @1, @2, etc variables are simply local variables within the I-type expression. This gives us the useful advantage of being able to nest compound I-type but does, as you suggest, prevent their use to retain values across uses

Re: [U2] Running total

2013-07-03 Thread Don Robinson
: Re: [U2] Running total Are you looking for @1?  This gives a column containing running total (I learned it from this list) DICT AP F1        invoice value (A type or I type)             T1        running total I type: F2:  @1 + F1 So, listing 3 items gives: LIST AP TOTAL F1 KATE 10:26:30am  03

Re: [U2] Running total

2013-07-03 Thread Wjhonson
need ten more dict items, one for each ? Or am I reading this solution wrong? -Original Message- From: Don Robinson donr_w...@yahoo.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Jul 3, 2013 6:54 am Subject: Re: [U2] Running total Kate, This gives strange results

Re: [U2] Running total

2013-07-03 Thread Kate Stanton
From: Kate Stanton k...@walstan.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, July 2, 2013 6:32 PM Subject: Re: [U2] Running total Are you looking for @1? This gives a column containing running total (I learned it from this list) DICT AP F1

Re: [U2] Running total

2013-07-03 Thread Wjhonson
Can anyone explain this situation better. I've only ever used the @ to simplify a few I-descriptors. I have a dict item SIZE that is just the LEN(@RECORD) So in this thread we've seen two EVAL solutions to a running total LIST VOC SIZE EVAL @1+SIZE LIST VOC SIZE EVAL SIZE + @2;@ In the first

Re: [U2] Running total

2013-07-03 Thread Peter Cheney
...@yahoo.com Subject: Re: [U2] Running total Can anyone explain this situation better. I've only ever used the @ to simplify a few I-descriptors. I have a dict item SIZE that is just the LEN(@RECORD) So in this thread we've seen two EVAL solutions to a running total LIST VOC SIZE EVAL @1+SIZE

Re: [U2] Running total

2013-07-03 Thread Kate Stanton
...@yahoo.com Subject: Re: [U2] Running total Can anyone explain this situation better. I've only ever used the @ to simplify a few I-descriptors. I have a dict item SIZE that is just the LEN(@RECORD) So in this thread we've seen two EVAL solutions to a running total LIST VOC SIZE EVAL @1+SIZE

Re: [U2] Running total

2013-07-03 Thread Hona, David
To: U2 Users List Subject: Re: [U2] Running total I believe the expression in the second example is referred to as a compound expression? Can't put my finger on the exact documentation but I seem to recall that compound expressions are broken up into parts (for want of a better term) delimited

Re: [U2] Running total

2013-07-02 Thread Martin Phillips
...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 02 July 2013 01:36 To: u2-users@listserver.u2ug.org Subject: [U2] Running total Teach me again how to do a running total in a Access/Recall/English report. I haven't done one in years, but I seem to recall that it's possible

Re: [U2] Running total

2013-07-02 Thread Charles Stevenson
...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 02 July 2013 01:36 To: u2-users@listserver.u2ug.org Subject: [U2] Running total Teach me again how to do a running total in a Access/Recall/English report. I haven't done one in years, but I seem to recall that it's possible

Re: [U2] Running total

2013-07-02 Thread Martin Phillips
To: U2 Users List Subject: Re: [U2] Running total LIST NEWACC BYTES EVAL BYTES+@2;@ VOC. Bytes.. BYTES+@2;@ ADDX 47 47 CHDIR 53100 ENDPAGE 54154 LNUM 64218 ___ U2

Re: [U2] Running total

2013-07-02 Thread George Gallen
, July 02, 2013 8:49 AM To: 'U2 Users List' Subject: Re: [U2] Running total Hmmm. Simpler than my approach but it fails with multivalues or with queries that have other I-types in them. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun

Re: [U2] Running total

2013-07-02 Thread Charles Stevenson
List Subject: Re: [U2] Running total LIST NEWACC BYTES EVAL BYTES+@2;@ VOC. Bytes.. BYTES+@2;@ ADDX 47 47 CHDIR 53100 ENDPAGE 54154 LNUM 64218 ___ U2-Users mailing

Re: [U2] Running total

2013-07-02 Thread Wjhonson
@listserver.u2ug.org Sent: Tue, Jul 2, 2013 10:08 am Subject: Re: [U2] Running total Martin, True, you might need mv-handling subrs for mv fields. Which are always fun. (I hate to concede that correlatives might actually be better at something, but I do wish there were a way to write a variation of an I

Re: [U2] Running total

2013-07-02 Thread David A. Green
: Monday, July 01, 2013 5:36 PM To: u2-users@listserver.u2ug.org Subject: [U2] Running total Teach me again how to do a running total in a Access/Recall/English report. I haven't done one in years, but I seem to recall that it's possible. ___ U2-Users

Re: [U2] Running total

2013-07-02 Thread Kate Stanton
...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 02 July 2013 01:36 To: u2-users@listserver.u2ug.org Subject: [U2] Running total Teach me again how to do a running total in a Access/Recall/English report. I haven't done one in years, but I seem

[U2] Running total

2013-07-01 Thread Wjhonson
Teach me again how to do a running total in a Access/Recall/English report. I haven't done one in years, but I seem to recall that it's possible. ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] Running total from UniData

2009-07-24 Thread Bill Haskett
Thanks, Kebbon. Why didn't I think about that?! Welcome to UD, where stupid things trip me up every day. :-) Bill Kebbon Irwin said the following on 7/24/2009 4:53 AM: I found that you had to take two steps, first an

[U2] Running total from UniVerse dict

2009-06-29 Thread Kate Stanton
I am sure we used to be able to do this using I-type, but I cannot remember how. Now we are using I-types again (not just ocreelatives), I want to be able to show each item outstanding for an account, with a running balance. Can anyone help? I have been to the doc, and read about CALC and

Re: [U2] Running total from UniVerse dict

2009-06-29 Thread Bernard Lubin
Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Tuesday, 30 June 2009 9:55 AM To: U2 Users List Subject: [U2] Running total from UniVerse dict I am sure we used to be able to do this using I-type, but I cannot

Re: [U2] Running total from UniVerse dict

2009-06-29 Thread David Jordan
Hi Kate I believe you are looking for the @ variables to solve your problem. I think in the uv help they come under the @ in the same area as the screen commands Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] Running total from UniVerse dict: THANKS!

2009-06-29 Thread Kate Stanton
...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Tuesday, 30 June 2009 9:55 AM To: U2 Users List Subject: [U2] Running total from UniVerse dict I am sure we used to be able to do this using I-type, but I cannot remember how. Now we are using I-types again (not just