>I have an index set on a view (index on name tag name). When I requery the view and there is data in the result set, it works fine. When there is not data in the result set, I get the following error:
>"Index does not match the table. Delete the index file and recreate the index."
>
>I've tried issuing DELETE TAG ALL, and DELETE TAG NAME, to no avail. I've also tried using an IDX index (index on name to tempname) - same problem. I feel like I'm missing something obvious here.
>
>Thanks in advance
I do exactly the same thing without problems. "NAME" is a reserved word in VFP so I would use a different tag name (and view column name, if possible).
If that doesn't help, post some code, determine your buffering mode, etc.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up