Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Temporary cursor indexing
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00532172
Message ID:
00532175
Views:
15
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform