You can manipulate the buffering mode in order to create an index (or indexes) on cursors
lnBuffermode = CURSORGETPROP("Buffering")
*-- force buffering to record
CURSORSETPROP("Buffering", 3)
INDEX ON <> TAG <> DESC ADDITIVE
CURSORSETPROP("Buffering", lnBuffermode)
I have this as a method in a SQL object to automatically index data coming back from remote cursors (SQL Server)
>>sequence the records. It works fine if I am using non-buffered view and
>>tables. But when I use view with table buffering, VFP stops me by saying
>>view with buffering cannot be indexed.
>
>In all the situations where the cursor or whatever didn't like indexing,
>it came to it that it didn't like having a structural index, but other
>indexes were fine. So:
>
>select myview
>dx_lc=sys(3) && or dx_lc=TempDir_gc+sys(3)
>Index on whatever tag first of (dx_lc)
>Index on anything tag second of (dx_lc)
>Index on another tag third of (dx_lc)
>
>This should work (I've never had a situation like yours, so I can't try
>it). Now I'm not sure the (dx_lc+".cdx") will be automatically deleted
>when you close the view - better check on that.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only