>>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   
>>

>>
>>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
>
>With the dbf alone no.
>With a second dbf yes.
>

>create cursor x (qty int)
>for k=1 to 100 && max(qty)
>  insert into x values (m.k)
>next
>select a.* from table a join x on x.qty <= a.qty into ...
>

Thank you.