Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Merge many rows into one row
Message
From
12/10/2006 06:33:17
 
 
To
12/10/2006 01:00:35
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:
01161407
Views:
19
Tariq,
See my amendment for you:-
2- Form1.getlist.method has following codes
Lpara ldFDATE   && Add a input parameter here
LOCAL lii,lcc
LOCAL ARRAY laPom(1)
lcc=""
*ldFDATE=THISform.text1.value && Needn't this line,removed.

SELECT GNO;
FROM WEIGHTS;
WHERE FDATE=ldFDATE ;
ORDER BY PCODE;
GROUP BY PCODE;
INTO ARRAY laPom
if _tally>0  &&  if no records selected,the array will not be created
FOR lii=1 TO ALEN(laPom,1)
lcc=lcc+laPom(lii)+","
NEXT
endif
RETURN IIF(LEN(lcc)=0,SPACE(150),LEFT(lcc,LEN(lcc)-1))
Steven
Previous
Reply
Map
View

Click here to load this message in the networking platform