Multiple key access in Quick

[Pickering, John (NORBORD)]

It depends on what file system you're talking about but the answer is
probably not.

But you could do something like:

file trans-dtl designer
  access via key1 using field1
  select if key2 of trans-dtl = field2 of xxx

In the access statement you should use whichever of key1 and key2 will
result in the fewest records.

John Pickering
Toronto

> -----Original Message-----
> From:	Santo Perri [SMTP:perri@excite.com]
> Sent:	Thursday, July 15, 1999 1:33 PM
> To:	POWERH-L@lists.swau.edu
> Subject:	Multiple key access in Quick
> 
> Is it possible to access a detail file by more that one key at a time?  Or
> do I have to create a new concatenated key of the two keys?
> 
> Eg.
> 
> FILE TRANS-DTL DESIGNER
>      ACCESS VIA KEY1,KEY2 USING FIELD1,FIELD2
> 
> Or is below my only option
> 
> FILE TRANS-DTL DESIGNER
>      ACCESS VIA KEY12 USING (FIELD1 + FIELD2)
> 
> The later means database and data changes that I really don't want to do.
> 
> Santo Perri
> Programmer / Analyst
> Cynaptec Information Systems
> 601 Main St.
> Shediac NB
> E0A 3G0
> 
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.