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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement