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:
01136061
Views:
15
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
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform