> Pls assist
>
> I'm trying to order the following select statement but it gives an error message
>
>
>
SELECT * FROM vpayroll;
> WHERE (STR(vpayroll.YEAR1,4,0)+RIGHT('00'+LTRIM(STR(vpayroll.PERIOD,2,0)),2)>=XSMALL ;
> .AND. STR(vpayroll.YEAR1,4,0)+RIGHT('00'+LTRIM(STR(vpayroll.PERIOD,2,0)),2) <=XLARGE);
> ORDER BY STR(vpayroll.YEAR1,4,0)+RIGHT('00'+LTRIM(STR(vpayroll.PERIOD,2,0)),2);
> INTO CURSOR GPAYROLL
>
> Please assist
SELECT * FROM Vpayroll WHERE PADL(year,4)+'00'+PADL(period,2) ;
BETWEEN M.xsmall AND M.xlarge ORDER BY <column ordinal cnumber(s)>
You can't order by expressions in VFP, only by column names or numbers. The numbers refer to the position of the column list in the query; the names can refer to the actual name or the column alias.
-Anders