Question:
We have to connect VFP to SQL Server, and we have a lot of non-structural index files for tables. We’ve created remote views for the tables and need to attach the non-structural indexes to the views. But we are not able to share the indexes. Why?
Answer:
Views (remote and local) are not tables. They are cursors. They are temporary buffered cursors that present a subset of backend information. Because they are cursors, any indexes you create against them are deleted automatically when the view is closed. Therefore they cannot be shared.