>LOCAL lCurrentDec >lCurrentDec=SET("Decimals") >SET DECIMALS TO 0 >SELECT name,PADL(MIN(VAL(item)),5,"0") as "Start", ; > PADL(MAX(VAL(item)),5,"0") as "End" ; > FROM MyTable ; > GROUP BY name ; > into CURSOR curMyTable >SET DECIMALS TO &lCurrentDecWouldn't it be the same as
SELECT name, ; MIN(item) as "Start", ; MAX(item) as "End" ; FROM MyTable ; GROUP BY name ; into CURSOR curMyTable?