macro substitution error in select statment 1

[KALEMO]

This statement works in VFP 2.6, but i get a "Group By Clause is missing or invalid" error when it is run in VFP 9:

sele lctable as table, lccond as condition, lcsource as grsource, ;
iif(type(lcsource) = "C", padr(alltrim(&lcsource),14), ltrim(trans(&lcsource, "$$$,$$$,$$$.99"))) as total, ;
coun(&lcsource) as cnt, recc() as totl, glc1, glc2, glc3, glc4, glc5, glc6, glnt ;
from datafile where glnt = grcode group by &lcsource into table temp

 

[ESquared]

This isn't the visual fox pro forum. It's the SQL Server forum. You'll need to ask your question there (if it exists, I don't know).

[COLOR=black #d0d0d0]My alarm clock causes time travel. When I hit snooze, no apparent time passes before the alarm sounds again, but the universe has in fact moved forward through time by ten minutes![/color]

 

[bborissov]

It exists
Kalemo, ESquared is right ask in VFP forums not here, check forum1252. I will be glad to answer you there.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP