Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Record out of range error on a view
Hi everyone,
I have a form that has a grid using a parameterized view on it. I have 2 drop down list that contol what is displayed in the grid and I am running VFP 5.0A.
Here is the problem. If I make a change to a field in the view but do not leave the field (Tableupdate is not called) and click on one of the dropdown lists and change the parameter when the grid gets focus I get an error "Record is out of range". While debuging this I see that when I get this error the view shows 0/6 in the status bar. If I go to the command window I can requery() and get the 6 records but when I resume and click back on the form I get the same error message.
I know that the Record is out of range error message usually means to reindex. I have done this on the base table but the problem seems to be with the view. I do have indexes on the view but they are recreated everytime I change the parameters.
Any Sugestions?
TIA
Jeff Whitaker
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement