>Hi,
>
>Can I SQL Select from a DBF table and increase a number of records according to a column?
>
>Here is an example.
>Table of the following structure:
>
>PART # PART DESCR QTY
>'ABC' Abc Part 1
>'CBS' Cbs Part 2
>'NBC' Nbc Part 5
>'ESPN" ESPN Part 0
>NFL NFL Part 10
>
I can't think of a way to do that with just SQL, but you can use SQL inside a loop.
Tamar
>
>Then the resulting cursor should have the same structure (resulting cursor of temporary name). And the number of records would increase according to the QTY column. For example, part "NBC" would be entered 5 times (5 records). And ESPN 0 records.
>
>TIA