Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Merge many rows into one row
Message
From
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:
01161376
Views:
15
Dear Sir,

1- Command1 has following codes

SELECT FDATE,thisform.GetList(FDATE) AS PARTY;
FROM WEIGHTS;
WHERE FDATE=THISform.text1.value ;
ORDER BY PCODE;
GROUP BY PCODE;
INTO cursor fix

2- Form1.getlist.method has following codes

LOCAL lii,lcc
LOCAL ARRAY laPom(1)
ldFDATE=THISform.text1.value

SELECT GNO;
FROM WEIGHTS;
WHERE FDATE=ldFDATE ;
ORDER BY PCODE;
GROUP BY PCODE;
INTO ARRAY laPom

lcc=""
FOR lii=1 TO ALEN(laPom,1)
lcc=lcc+laPom(lii)+","
NEXT

RETURN IIF(LEN(lcc)=0,SPACE(150),LEFT(lcc,LEN(lcc)-1))

When I press Command1 it shows following error message

NO PARAMETER statment found

What is wrong?

Please help
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform