General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
View giving error in grid - Rec out of range (5)
Environment versions
Network:
Windows 2003 Server
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
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