>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.