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