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
Title:
View giving error in grid - Rec out of range (5)
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01136052
Message ID:
01136052
Views:
70
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
Next
Reply
Map
View

Click here to load this message in the networking platform