Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View giving error in grid - Rec out of range (5)
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01136052
Message ID:
01136078
Views:
12
Unfortunately this doesn't change anything. Thanks...

>Add after REQUERY()
Thisform.Grid.Refresh()
>
>>I have a grid based on a view with a parameter called nUserGroup. View is bugffering set to 5.
>>
>>It is set as public in the form.
>>
>>I have a combobox that in the lostfocus event takes its value and requeries the view.
>>i.e.
>>nUserGroup=this.value
>>select (UserGroupItems)
>>=requery()
>>
>>Then the resultant view is displayed in a grid.
>>The grid is setup by default as readonly.
>>
>>When I click in any column I get the above error
>>i.e. Record is out of range, (5)
>>If I look in the debug mode. it is occuring in the mousedown event of the grid.
>>In the debugger, the alias() is the grid record source, i.e. the view...
>>the number of records reccount() is 1, and the recno() is 1 as well.
>>
>>What does this mean out of range... isn't 1 in range?
>>
>>What am I doing wrong??
>>
>>TIA,
>>Mike
Previous
Reply
Map
View

Click here to load this message in the networking platform