Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trying Again - Error - Record is out of range in view
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Trying Again - Error - Record is out of range in view
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01136617
Message ID:
01136617
Vues:
66
I asked this question before, got a lot of good answers but none worked.

Setup:
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 on the form that in the lostfocus event takes its value
and requeries the view.
i.e.
nUserGroup=this.value
select (UserGroupItems)
=requery()
thisform.grdUserGroupItems.setfocus()
Thisform.cmdAccess.setfocus()

Then the resultant view is displayed in a grid.
The columns in the grid are populated by:
a combobox, populated via an SQL statement. It's column is bound to the
underlying data source. The other 7 columns are check boxes.

The combobox has a property, cGridAlias, which is set in its init to be
equal to the source table for the grid. In the lost focus event of the
combo, I select (.cGridAlias) as the last line of the code. The error does
not appear until I click on one of the checkboxes. By default the grid is
set as readonly=.t. until I unlock it.

In the init of the grid, I run a BldGrid method that adds the combobox and
the check boxes to the appropiate columns. Then a routine runs called
SetGrid to fill in the properties for the columns, i.e. width,
controlsource, activecontrol etc. The final routine run upon init, resizes
the grid. This is how I setup the grid.

If I click the combobox, and then one of the checkboxes right afterwards,
the error Record out of range occurs... (5)

If I look in the debugger, 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. I also
noted that the value in the column changed, even though I didn't change it.

What does this mean out of range... isn't 1 in range?

What am I doing wrong??

TIA,
Michael Savage. E-mail: msavage@golden.net
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform