application problem

[Maloney, Charlie]

(Margaret-)Abra-Cadabra, here is: 
"a dummy master file used just for this process 
 with some tricks played with keys, etc."

No guarantees for syntactical correctness.

1:  Assume the following:

part a qty 5 means 
"print 5 labels for part record a"
part b qty 2 means
"print 2 labels for part record b"
part c qty  10 means 
"print 10 labels for part record c"

2:  Create an indexed file ONE item.

FILE LABEL_DRIVER Org Indexed Open LABELDRV
Record LABEL_DRIVER
  Item QUANTITY Integer Size 2

Index QUANTITY_INDEX ; non-unique
  Segment QUANTITY Integer Size 2

3:  Add the following data to the file with
   QUICK, COBOL, Visual Basic or
   Some other procedural language as follows:

Add ONE   record  with QUANTITY 1
Add TWO   records with QUANTITY 2
Add THREE records with QUANTITY 3
Add FOUR  records with QUANTITY 4
Add FIVE  records with QUANTITY 5
etc.

Here's what the first fifteen records look like:
1
2
2
3
3
3
4
4
4
4
5
5
5
5
5
etc.

4:  If you require record uniqueness for a relational table,
    use the record count.

5:  Link to this file as follows:

ACCESS yourfile LINK qty to QUANTITY of LABEL_DRIVER 
REPORT whatever
GO

We teach this in one of the Advanced PH courses.

  /cm

-----Original Message-----
From: Hasse, Christina [mailto:Christina.Hasse@Cognos.COM]
Sent: Friday, November 17, 2000 5:32 PM
To: 'powerh-l@sphere.swau.edu'
Subject: FW: application problem


Hi All,

Can someone help this person?

Thanks,

Christina

-----Original Message-----
From: Joe Grimland [mailto:Joe.Grimland@forneycorp.com] 
Sent: Friday, November 17, 2000 12:55 PM
To: Hasse, Christina
Subject: R: application problem


hi christina i was out of ofc yesterday
i have a subfile of records and the user accesses and update it with a small
quick program. they put a qty on the part records
they want labels printed for. then i have a quiz program that selects those
part
records with quantities, eg. 3 records, part a qty 5, part b qty 2 and part
c
qty 10
p.s
i tried your sugestion and probably have something wrong. i wrote a subfile
one
record, part a, qty 5. one record, two fields
then i wrote a quiz to read that record. i put the set rep lim qty where qty
is
the field name in the record.
i tried it b4 the the acc statement and after. it did not like the qty.

i appreciate your help, joe

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.