This may be an easy one, or a hard one, however, I realized I don't recall
ever having to do this until today, or I could just be tired...
How can you do a SELECT from two different files in a BASIC program and then
combine the lists of ID's so that you can do a READNEXT on it?
I ask this
try:
HELP MERGE.LIST
John Thompson wrote:
This may be an easy one, or a hard one, however, I realized I don't recall
ever having to do this until today, or I could just be tired...
How can you do a SELECT from two different files in a BASIC program and then
combine the lists of ID's so that
In a nutshell
SELECT FILE WITH VALUE = 'A' TO 1
SELECT FILE WITH VALUE = 'B' TO 2
MERGE.LIST 1 UNION 2 TO 0
SORT FILE VALUE
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: Wednesday, July
I'm not sure I'd combine them; handle the data once.
I'd readext through file1_list, then readnext through file2_list.
...and I'd probably use the basic select, making AMOUNT=112.50 my first
filter. Again, then you only read the data once. (Exception: if the field is
indexed, I'd go with an
Thanks for the help. You guys are way better than typing in the word LIST
in the pdf manuals and hoping to find what you are looking for :)
On Wed, Jul 27, 2011 at 1:26 PM, Dan Fitzgerald dangf...@hotmail.comwrote:
I'm not sure I'd combine them; handle the data once.
I'd readext through
Ok, got stuck again...
How would your example play out in BASIC?
Its just a bunch of archive info in a file that only has a couple of
indexes, but, I would like to look at the active file as well...
EXECUTE \SELECT FILE1 WITH VALUE = 'A' TO 1\
EXECUTE \SELECT FILE2 WITH VALUE = 'A' TO 2\
EXECUTE SELECT FILE WITH VALUE = 'A' TO 1
EXECUTE SELECT FILE WITH VALUE = 'B' TO 2
EXECUTE MERGE.LIST 1 UNION 2 TO 0
TOT.VAL = 0
END.OF.LIST = FALSE
LOOP
READNEXT KEY FROM 0 ELSE END.OF.LIST = TRUE
UNTIL END.OF.LIST = TRUE DO
READ RECORD FROM FILE, KEY THEN
VALUE=
If I understand correctly, you're going to end up with a list that has
entities from two files, therefore you're going to need to do a test when
you do the read to see which file the ID came from and ergo which file to
read
So to add to the code below, you'd need
READ RECORD FROM FILE1, KEY THEN
Yes it occurred to me some minutes ago that they ID's in the two files are
different, so you are correct.
So I'll probably end up just doing the two readnext's anyway like a previous
poster suggested.
However, thanks for all the examples.
I started out on an older PICK system that did not have
John Said
and sometimes I wish they just stored the lists in a BASIC program as
dynamic arrays...
There is the READLIST verb. That takes a list and makes a dynamic array
with it. P type uses READSELECT.
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
The lists are stored in SAVEDLISTS as a multi-attribute dynamic array
John Thompson wrote:
Yes it occurred to me some minutes ago that they ID's in the two files are
different, so you are correct.
So I'll probably end up just doing the two readnext's anyway like a previous
poster suggested.
John,
I'm guessing you're using a PICK account, to use numbered select lists in these
accounts you must have $OPTIONS -S in the code. Also multiple TCL commands can
be combined together just as in a PA VOC type avoiding the need for multiple
EXECUTE's so the code could look something like
12 matches
Mail list logo
