Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View giving error in grid - Rec out of range (5)
Message
Information générale
Forum:
Visual FoxPro
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
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01136052
Message ID:
01136052
Vues:
71
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
Fil
Voir

Click here to load this message in the networking platform