Hi all,
Is it possible to create 2 indexs on a temporary cursor ?

SELECT stkitem.itemcode, Stkitem.brand, Stkitem.cat, Stkitem.desc ,;
SUM(iif(split = .F.,Items.qty,0)) AS Qty,SUM(iif(split = .t.,Items.qty,0)) AS Splitqty, round(SUM(Items.totalcost),2) AS TotalCost, Stkitem.code as Supplier ;
FROM stock!stkitem LEFT OUTER JOIN stock!items;
ON Items.itemcode = Stkitem.itemcode;
GROUP BY stkitem.itemcode;
ORDER BY Stkitem.desc into cursor mystock

sele mystock
index on itemcode tag item
index on mystock.desc tag Itemdesc && Error #$%#$%.tmp read only


T.I.A

Patrick