Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
View giving error in grid - Rec out of range (5)
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement