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: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 such as Field mv1 1 mv2 2 mv3 3 Field mv1 1 mv2 2 etc ive only ever been able to do it as a pick style dict item or as a subr jak - Original Message - From: Garth Joubert [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, April 02, 2004 11:52 AM Subject: RE: Running total Well the quick and dirty way is: LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME Above assumes CUST.NAME is multivalued. Unfortunately the Counter only shows per row and not per multivalued, but again it is only a quick and dirty. Hope this helps. -Original Message- From: John Kent [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 [EMAIL PROTECTED] Sent: Friday, April 02, 2004 7:49 AM 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: Shrestha, Prabhash [mailto:[EMAIL PROTECTED] Sent: Friday, 2 April 2004 10:08 a.m. To: U2 Users Discussion List Subject: Running total 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 1 Joe Jones 112 2 Sue Smith 223 3 Sally White Thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Running total
John,
Try this for your itype
SMM.CNT
0001 I
0002 @RECORD11
0003 A;NV
0004 Count
0005 3R
0006 M
Stewart
-Original Message-
From: John Kent [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 April 2004 15:14
To: U2 Users Discussion List
Subject: 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
jak
- 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 is the
product id field.
CT DICT CUSTOMER SMM.CNT
SMM.DCNT
0001 D
0002 11
0003 A;NV
0004 Count
0005 3R
0006 M
SMM.ICNT
0001 I
0002 OCONV(PRODID,'A;NV')
0003 MD0
0004 Count
0005 3R
0006 M
it is still using pick conversion but they are valid conversions in D I
type dictionaries.
Stewart
-Original Message-
From: John Kent [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 April 2004 14:19
To: U2 Users Discussion List
Subject: Re: Running total
Stewart,
tried that and all i get is the entry of 1 beside each multivalue
instead of incrementing mv numbers.
I am wondering if this is a information flavour thing.
Tried it in HS.SALES and its the same problem
The EVAL works though but its still the pick solution
jak
- Original 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
0002: mvfield.name;@NV
0003: MD0
0004: Count
0005: 3R
0006: M
0007:
:
I could not get it to work without using good old pick conversions for
EVAL.
EVAL @RECORDmvfld.no CONV A;NV
EVAL OCONV('','F;mvfld.no;NV')
Regards,
Stewart
-Original Message-
From: John Kent [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 April 2004 13:32
To: U2 Users Discussion List
Subject: Re: Running total
Stewart
try this, works for me in universe information flavour and on R83
1 D
2 15
3 MV name
7 A;NV
9R
105
from ye olde pick pocket guide version IV
NV returns the number of the mulit-value being processed
hows life at fauldings ?
jak
- Original Message -
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: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
such as
Field mv1 1
mv2 2
mv3 3
Field mv1 1
mv2 2
etc
ive only ever been able to do it as a pick style dict item or as a
subr
jak
- Original Message -
From: Garth Joubert [EMAIL PROTECTED]
To: U2 Users Discussion List [EMAIL PROTECTED]
Sent: Friday, April 02, 2004 11:52 AM
Subject: RE: Running total
Well the quick and dirty way is:
LIST CUST EVAL @1 + DCOUNT(CUST.NAME,@VM) CUST.NAME
Above assumes CUST.NAME is multivalued. Unfortunately the Counter only
shows per row and not per multivalued, but again it is only a quick
and
dirty.
Hope this helps.
-Original Message-
From: John Kent [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 [EMAIL PROTECTED]
Sent: Friday, April 02, 2004 7:49 AM
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: Shrestha, Prabhash [mailto:[EMAIL PROTECTED]
Sent: Friday, 2 April 2004 10:08 a.m.
To: U2 Users Discussion List
Subject: Running total
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 Running
RE: Data typing in MV Basic
Wol, It is not how the compiler deals with the information but how the runtime engine deals with the data. I have demonstrated the runtime engine types the data based on how it is entered in the source code. A = 1 is typed as a numeric by the runtime engine and A = 1 is typed as a string. In an earlier post I provided the following proof. TST 0001 DEBUG 0002 A = 1 0003 A = 1 0004 STOP RUN XP TST TST: 2: A = 1 :: S TST: 3: A = 1 :: A/ INTEGER: 1 :: S TST: 4: STOP :: A/ STRING: T r L=1 `1' :: The program simply sets the variable A to 1 or 1 and when run it goes in to debug mode. I then stepped through each line and displayed the contents of the variable A by typing A/ as you can see the runtime engine reports each line as INTEGER or STRING depending on how the data was entered in the source code. Regards, Stewart -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, 31 March 2004 19:15 To: U2 Users Discussion List Subject: RE: Data typing in MV Basic Why? Let's work on the basic principal of coercion occurs when necessary, and not before. The compiler detects 1 as a string literal. It stores it as a literal. The compiler detects 1 as a numeric literal. It stores it as a literal. (The compiler doesn't give a damn about strings or numerics - a literal is a literal is a literal) Therefore 'A = 1' and 'A = 1' both result in IDENTICAL p-code. Therefore, unless you know how the compiler works, your conclusion is demonstrably flawed. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell, Stewart Sent: 31 March 2004 08:31 To: 'U2 Users Discussion List' Subject: RE: Data typing in MV Basic A = 1 is held as an integer A = 1 is held as a string A = 1 + 0 is held as an integer Cheers, Stewart -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, 31 March 2004 17:00 To: U2 Users Discussion List Subject: RE: Data typing in MV Basic You've missed the point! :-) These two statements apparently have exactly the same effect - the question is do they? A = 1 A = 1 (In the stuff I'm writing, they'd be the same - everything is a string until it is forced into numeric.) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Garratt Sent: 31 March 2004 07:39 To: U2 Users Discussion List Subject: Re: Data typing in MV Basic Would this not be set by your initialisation of the variable A. eg A = '';*Alpha/Numeric or String A = 0 ; Numeric - Original Message - From: Trevor Ockenden [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 2:25 PM Subject: Re: Data typing in MV Basic Will, I stand corrected on that one. So far in 20 odd years of programming in MV I haven't needed to worry about it. Now Will raises a terrific question. If A = 1 assigns 1 as numeric. How would you determine if A contained a numeric or a string in this case? My short answer is - why would I need to know? BUT I'm sure somebody has a good answer to that one. Cheers Trevor Ockenden Open Systems Professionals - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 4:10 PM Subject: Re: Data typing in MV Basic In a message dated 3/30/2004 8:19:18 PM Pacific Standard Time, [EMAIL PROTECTED] writes: A = 1 assigns a numeric integer. The expression need not contain operators (+,-,etc) to be numeric. A = 1 assigns a string however, as you have explicitly declared it to be string. A = 1 + 2 assigns a numeric integer value (3) as the result is numeric. A = one + 2 assigns a zero - according to the error message. yes no yes yes they all assign numerics imho 1 is cast as a numeric because the system is smart enough to realize its a numeric string and has no purpose casting it as a string Any idea how to test which it is? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 25/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify
RE: Modern Universe (TESTING)
Joe, You can use an SQL query against normal UV files in the same manner you would agains tables. Cheers, Stewart -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] Sent: Thursday, 1 April 2004 6:03 To: U2 Users Discussion List Subject: RE: Modern Universe (TESTING) Tim, My apologies... Yes, i know UV has a SQL Interface but i didnt think many UV Programmers used this Interface... As a matter of Fact, i like the UV SQL Interface. I have a PE Edition of UV on all my machines and i have only used the SQL Interface within UV. In our UV Shop, UV Guys are NOT supposed to use this SQL Interface as they claim its very slow than using the Native SELECT WITH . I have read the UV Manual that reflects RDBMS, this manual explains you can setup Tables Exactly like any RDBMS using Data Types (Varchar, char, Int etc) All the the testing i have done does NOT involve using the SQL Interface in UV, Our UV Shop uses FILE Types, NOT RDBMS Tables and we use PICK/BASIC/REDBACK to Interfact with these FILES. Perhaps the problem might be our UV Shop using PICK/BASIC... Maybe the SQL Interface on UV is much faster. I dont know. Thanks, Joe Eugene From: [EMAIL PROTECTED] on behalf of Timothy Snyder Sent: Wed 3/31/2004 3:12 PM To: U2 Users Discussion List Subject: RE: Modern Universe (TESTING) Joe Eugene wrote on 03/31/2004 02:59:29 PM: Please post your PICK/BASIC and SQL Query.. so we i can learn the magic you did on the PICK Side. Joe, Unless I'm missing something, Sara used the SQL statement against the UniVerse database. Perhaps you weren't aware that UniVerse supports SQL statements to query the database. I don't think she used any magic. Therefore, in her original post, she provided all the information you need to do a comparison. Also, you keep referencing PICK/BASIC. BASIC is the programming language, not the query language. There is also a native query language, but that's only one of many ways to access the database. I hope this helps to clarify your expectations. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services Office (717) 545-6403 (rolls to cell phone) [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Document scan and retrieval (looking for software)
Hi All, Does anyone know of any products available for document scanning and retrieval with interfaces for Universe. Or any products that have a reasonable API so we can create our own interface. Regards, Stewart Mitchell Manager, Core Distribution Systems Mayne Pharmacy Services IT mailto:[EMAIL PROTECTED] application/ms-tnef___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
