General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only