Re: Qryout file problem

[Wechsler <ywexler@xxxxxxx>]

John,
at the time I write this letter you already got some answers and I see
you prefer the Query.
The question is if you need to use the new file (single record for pn
but multiple locations)
regularly but your app. updates the old file.
If this is the situation, I think the best is to create a Join logical
file based on your original file
with selects, e.g. if you have n locations, use the same file (the
original one) n times with selects
of records, for each join select on a diferent location.
In this way, you create once the file needed but you continue to update
the original file as before.
If you use query or even a program, you have to recreate or update the
new file each time you need to use it.

Yossi Wechsler

John Taylor wrote:

>
>
> If anyone can find a way to resolve this problem it would make my
> week.
>
> I need to generate a file containing part numbers and locations with
> one record per part number with multiple locations, from a file
> containing multiple records per part number.
>
> eg from this    Part Number     Location
>                 1234            A001A
>                 1234            A003C
>                 1234            C010D
>                 4567            A009B
>                 4321            B001A
>                 4321            B012D
>
> to this         1234            A001A   A003C   C010D
>                 4567            A009B
>                 4321            B001A   B012D
>
> I believe I can do this using multiple queries utilising result fields
> and summaries but as of now I have not fathomed it out.
>
> Thanks
>
> John



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---