Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record out of range error on a view
Message
 
À
27/12/1999 15:06:47
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:
00310171
Vues:
25
Jeff,
Some questions (in part repeating what Ricardo asked)

1) Does this happen when you have NOT changed data in the grid?

2) Are your tables/views row or table buffered? If row buffered then Tableupdate() will be called by VFP whenever you change rows.

3) Is there any outstanding unchanged data ANYWHERE when you get the error?

4) What code is in the GotFocus, When and InteractiveChange methods for the combo? Just to requery the view?

5) If it's a parameterized view, how is the parameter set?

6) If necessary do you do a combo requery (to refresh the data) after doing a view requery? This is particularly important, as the data in a combo must be requeried to reflect the underlying data if the view/array/table/cursor changes.

HTH
Barbara

>Barbara,
>
>Sorry it took so long to get back to you.
>
>Yes, I have tried everything that I can think of. I have Tableupdate() everywhere (including the click event of the drop down lists) so I know the buffer is clear.
>
>Here is some more info on the problem:
>
>I start the grid with one view, based on which dropdown list the user selects I change to a different view, reset the control source of the grid and recordsource of each column, then add indexes to the view. When I step through the code it gets back to the read events with out error. It is only when I click on the grid (or form) that I get the error.
>
>The steps that I take to recreate the error are as follows:
>
>bring up form with viewA
>using drop down list change to viewB
>change a record in the grid and without moving off of the field go back to the drop down list and change the parameter. (this will do a requery of viewB)
>click on the form/grid
>error "Record out of range"
>
>Thanks for the help
>
>Jeff
>
>>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