dictionary look like?
Thanks.
Ed Burwell
[EMAIL PROTECTED]
973.361.5400 x1512
-Original Message-
From: Bruce Lunt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 12:26 PM
To: [EMAIL PROTECTED]
Subject: RE: Memo: RE: [UD] Union Query
What I have done in the past is concatenate the 2
From: Burwell, Edward [EMAIL PROTECTED]
To: 'U2 Users Discussion List' [EMAIL PROTECTED]
Sent: Friday, April 30, 2004 1:41 PM
Subject: RE: Memo: RE: [UD] Union Query
R. Bruce,
Could you give an example? I'm having trouble envisioning this.
Let's say I have these keys in a list
,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,)
003:
004: NAME
005: 25L
006: S
-Original Message-
From: Allen Egerton [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 1:47 PM
To: U2 Users Discussion List
Subject: Re: Memo: RE: [UD] Union Query
From: Burwell, Edward [EMAIL PROTECTED]
To: 'U2
From: Burwell, Edward [EMAIL PROTECTED]
To: 'U2 Users Discussion List' [EMAIL PROTECTED]
Sent: Friday, April 30, 2004 2:00 PM
Subject: RE: Memo: RE: [UD] Union Query
Does that work for you? It doesn't work for me.
ORDER.FILE NAME.
114061 C.M.O.S. INC. *ASC*
114062
Users Discussion List [EMAIL PROTECTED]
To: 'U2 Users Discussion List' [EMAIL PROTECTED]
Subject: RE: Memo: RE: [UD] Union Query
Date: Fri, 30 Apr 2004 13:41:26 -0400
R. Bruce,
Could you give an example? I'm having trouble envisioning this.
Let's say I have these keys in a list:
LOCAL.1
LOCAL.2
]
973.361.5400 x1512
-Original Message-
From: Bruce Lunt [mailto:[EMAIL PROTECTED]
Sent: Friday, April 30, 2004 3:59 PM
To: [EMAIL PROTECTED]
Subject: RE: Memo: RE: [UD] Union Query
In the dict of FILE.A create a dict called: NAME.LO that has:
TRANS(LOCAL,ID,1,X):TRANS(OTHER,ID,1,X)
What you
to decide what do to do with that.
Again, sorry for not testing out my solution before I offered it.
Regards,
Bruce
From: Allen Egerton [EMAIL PROTECTED]
Reply-To: U2 Users Discussion List [EMAIL PROTECTED]
To: U2 Users Discussion List [EMAIL PROTECTED]
Subject: Re: Memo: RE: [UD] Union Query
Date
as well.
Thanks.
- Original Message -
From: Bruce Lunt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 30, 2004 10:11 PM
Subject: Re: Memo: RE: [UD] Union Query
Open mouth, ... insert foot. Or whatever :)
I'm sorry, I spoke too quickly. The ID's are needed in the primary
In a message dated 4/30/2004 10:11:05 PM Eastern Daylight Time, [EMAIL PROTECTED]
writes:
001: I
002:
TRANS(ORDER.FILE,@ID,3,):TRANS(ORDER.FILE.CAN,@ID,3,)
003:
004: NAME
005: 25L
006: S
But could'nt you do something like
IF TRANS(ORDER.FILE,@ID,3,) = THEN