>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.
Thanks, guys. Your tips are useful and I've got it working.
Previous
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