FoxPro database connector - Cannot update cursor

Author

Cannot update cursor

Puebles

2005-10-27, 8:34 am

I have been receiving error 11 - "Cannot update cursor" when running either a
compiled application or executable. This includes applications written 8
years ago that worked until I have recently opened them. I am using VFP 5.0.
Here is an example of the problem and what I have tried.

I have created a variety of forms, all using grids, that display tables,
both free and contained in a dbc. I have used tables filtered and not,
ordered and not, exclusive and not. I have launched the screen from another
screen and from a menu. I have created the forms in formsets and alone. I
have programatically opened the tables. I have even preceded each code usage
with "if used(...." or close tables all and then "use .......... exclusive"
or "use .........again". I have had messageboxes display the datasession,
tables, etc.

All forms work until I do one of the following;
1) Issue the command "Append Blank"
2) Use any command that begins with "Thisform" or "Thisformset" with the
possible exclusion of "Thisform.Refresh"
3) call a defined form or formset property or method regardless of content,
even blank or commented out.
4) call a program file, procedure or function external to the form but
included in the project.

Here is an example of the steps and what happens.
1) Create and modify a new form, populate and format data environment, add
and format a grid, add button to close the form with thisform or
thisformset.release.
1.1) Save the form and rebuild the project and run under vfp 5.0
environment. All OK.
1.2) Compile as an executable, Close VFP, EXE, all OK.
2) Modify form adding "OnMouseUp" event to headers to sort ascending or
descending (with 'control' key)
2.1) Repeat step 1.1, testing sort feature, all OK.
2.2) Repeat step 1.2, testing sort feature, all OK.
3) Modify form adding a button to add a new record to the grid. Create
'Click' event with 'Append Blank'.
3.1) Repeat step 1.1, testing Add New feature, all OK.
3.2) Repeat step 1.2, testing Add New feature, Error 111 Cannot update cursor.

I have modified every conceivable grid property including AllowAddNew,
ReadOnly, Enabled. I have created new projects, tables, and databases. I have
programatically opened tables and successfully made changes. I am beyond lost
at this point. MS says VFP 5.0 is not supported, no help there.

Eric den Doop

2005-10-27, 8:34 am

You can get this error if a table is opened in read only mode (eg. USE
yourtable NOUPDATE). I don't remember if that was possible in VFP5 though...
check the file attributes and folder security settings.
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts
Microsoft MVP for Visual FoxPro

"Puebles" <Puebles@discussions.microsoft.com> wrote in message
news:A9244099-A9D1-4D23-B635- 67078D7DFDAF@microso
ft.com...
>I have been receiving error 11 - "Cannot update cursor" when running either
>a
> compiled application or executable. This includes applications written 8
> years ago that worked until I have recently opened them. I am using VFP
> 5.0.
> Here is an example of the problem and what I have tried.
>
> I have created a variety of forms, all using grids, that display tables,
> both free and contained in a dbc. I have used tables filtered and not,
> ordered and not, exclusive and not. I have launched the screen from
> another
> screen and from a menu. I have created the forms in formsets and alone. I
> have programatically opened the tables. I have even preceded each code
> usage
> with "if used(...." or close tables all and then "use ..........
> exclusive"
> or "use .........again". I have had messageboxes display the datasession,
> tables, etc.
>
> All forms work until I do one of the following;
> 1) Issue the command "Append Blank"
> 2) Use any command that begins with "Thisform" or "Thisformset" with the
> possible exclusion of "Thisform.Refresh"
> 3) call a defined form or formset property or method regardless of
> content,
> even blank or commented out.
> 4) call a program file, procedure or function external to the form but
> included in the project.
>
> Here is an example of the steps and what happens.
> 1) Create and modify a new form, populate and format data environment, add
> and format a grid, add button to close the form with thisform or
> thisformset.release.
> 1.1) Save the form and rebuild the project and run under vfp 5.0
> environment. All OK.
> 1.2) Compile as an executable, Close VFP, EXE, all OK.
> 2) Modify form adding "OnMouseUp" event to headers to sort ascending or
> descending (with 'control' key)
> 2.1) Repeat step 1.1, testing sort feature, all OK.
> 2.2) Repeat step 1.2, testing sort feature, all OK.
> 3) Modify form adding a button to add a new record to the grid. Create
> 'Click' event with 'Append Blank'.
> 3.1) Repeat step 1.1, testing Add New feature, all OK.
> 3.2) Repeat step 1.2, testing Add New feature, Error 111 Cannot update
> cursor.
>
> I have modified every conceivable grid property including AllowAddNew,
> ReadOnly, Enabled. I have created new projects, tables, and databases. I
> have
> programatically opened tables and successfully made changes. I am beyond
> lost
> at this point. MS says VFP 5.0 is not supported, no help there.

Sponsored Links