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
ed to know 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
MAIL PROTECTED]>
Subject: Re: Memo: RE: [UD] Union Query
Date: Fri, 30 Apr 2004 14:41:17 -0400
From: "Burwell, Edward" <[EMAIL PROTECTED]>
To: "'U2 Users Discussion List'" <[EMAIL PROTECTED]>
Sent: Friday, April 30, 2004 2:00 PM
Subject: RE: Me
)
Ed Burwell
[EMAIL PROTECTED]
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("LOC
cell
From: "Burwell, Edward" <[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: Fri, 30 Apr 2004 13:41:26 -0400
R. Bruce,
Could you give
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.FI
ORDER.FILE",@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 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 e
d the NAME 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 concate
lt;[EMAIL PROTECTED]>
Subject: Memo: RE: [UD] Union Query
Date: Fri, 30 Apr 2004 16:49:46 +0100
Hi Ed,
You could test for the record existing in one file and if it does use the
dict for that file otherwise use the dict for the other file:
TRANS("FILE.A",ID,1,"X"); IF @1 <&
Hi Ed,
You could test for the record existing in one file and if it does use the
dict for that file otherwise use the dict for the other file:
TRANS("FILE.A",ID,1,"X"); IF @1 <> '' THEN FILEA.NAME ELSE FILEB.NAME
where FILEA.NAME returns the name from FILE.A and FILEB.NAME returns the
name
11 matches
Mail list logo