Yes and No,
Do your select into mycursor then
use dbf('mycursor') in 0 again alias myrwcursor nofilter
you can now treat it like a rw cursor
all this goes away with vfp 7
hth
Jeff
>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
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com