Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you Pack a Cursor
Message
From
06/11/2012 11:18:14
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01556496
Message ID:
01556498
Views:
100
>I have a Select into a Cursor readwrite and then 'Postprocess' the cursor removing rows based on various conditions
>I then want to 'Pack' the cursor but dont seem to be able to do it
>Any way of doing it
>
>(After removing rows, I then need to use the cursor as the basis of an update, and want to speed it up as much as possible (can be millions of rows) , so want to Pack to improve performance
>
>Tia,
>Gerard

First of all: yes, a readwrite cursor can be packed. However, I would rather add a logical field for your purpose, and also create a binary index tag on this field. Index on YourField tag yourtag binary.

Update: Sorry, I mixed Zap and Pack, a cursor can be Zapped, but clearly not Packed. But isn't that why we have Set Deleted On as default? Anyway, use an extra field, that's much easier and possibly also quicker in this case.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform