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.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
