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 AMERICAN PERFIT XSTAL
> 122228 TIMELAND COMPANY
> 122229 MCCANN ELECTRONICS *STR*
> 130395 TERMINAL TECH SERVICE
> 138562 TOWN VISION ELECTRONICS
> 154897 CASIO SERV CENTER *ASC*
> 163063 CASIO SERV CENTER *ASC*
> 171230 AMERICAN PERFIT XSTAL
> 195731 ELECT MUSIC INSTR *FAS*
> 10 records listed
> Enter <CR> to print non exist record ids
> 007890
> 007891
> 007892
> 007893
> 007894
> 016057
> 016058
> 016059
> 016060
> 016061
>
> Here is the dict:
>
> 001: I
> 002: TRANS("ORDER.FILE",@ID,3,""):TRANS("ORDER.FILE.CAN",@ID,3,"")
> 003:
> 004: NAME
> 005: 25L
> 006: S
I can't test it right now, I don't have access to a Universe machine until
tonight. Try an ID.SUP, 'cause the ids for ORDER.FILE.CAN certainly aren't
in ORDER.FILE.
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
