Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need a clever Idea
Message
 
 
To
03/10/2002 11:31:47
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00707362
Message ID:
00707403
Views:
25
Something like
CREATE CURSOR dummy ( seqnum i)
SELECT MAX(Qty) ;
	FROM mytable ;
	INTO ARRAY laMaxQty

FOR i=1 TO laMaxQty
	INSERT INTO dummy VALUES (i)
ENDFOR

SELECT mytable.* ;
	FROM mytable ;
		JOIN dummy ON mytable.qty >= dummy.seqnum
>Hi. I have a table that contains a product code, description and a quantity. I want to create an sql statement in order to product bar code labels. I cant figure out how to breakdown the quantity so I get a cursor with for each product the number of records relating to the quantity.ie.
>Part A is 3, Part B is 2 so I want:
> Part A
> Part A
> Part A
> Part B
> Part B
>
>Does anyone know a clever way to get this?
>
>TIA,
>
>Sandi
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform