Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trying Again - Error - Record is out of range in view
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Trying Again - Error - Record is out of range in view
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01136617
Message ID:
01136617
Views:
65
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
Next
Reply
Map
View

Click here to load this message in the networking platform