Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record out of range error on a view
Message
 
À
17/12/1999 12:35:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00305349
Message ID:
00306517
Vues:
27
Jeff,
This is pretty simple-minded, but have you done a grid refresh as part changing the dropdown lists? Also, if you are requerying the view without doing a tableupdate(), you should probably do a tablerevert() to clear all buffered data out of the view before the Requery() is called.

HTH
Barbara

>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
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform