Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Merge many rows into one row
Message
From
13/10/2006 01:54:22
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01161133
Message ID:
01161651
Views:
11
Dear all,

Thank you very much for helping me.

I got following solution by Mr. Borislav Borissov
The following brief codes work fine for me
SELECT distinct(pcode)as pcode,gno,fdate,party;
	FROM WEIGHTS;
	WHERE fdate=THISform.text1.VALUE ;
	ORDER BY pcode;
	GROUP BY PCode;
	INTO cursor fix

SELECT OUT2
ZAP

APPEND FROM DBF("FIX")

LOCAL lcMessage
lcMessage = ""

SELECT fix
SCATTER memv
SCAN
	lcMessage = m.lcMessage + ALLTRIM(transform(gno))+alltrim("-")
	SELECT out2
	REPLACE party with lcMessage
ENDSCAN

SELECT out2
BROW fields fdate,pcode,gno,party
Previous
Reply
Map
View

Click here to load this message in the networking platform