Error 111: Cannot update the cursor.

[Rogerio Braudes]

Hello, I´m brazilian!
I want to know the solution of this problem.
My cursors in the project, can be update succesfully! But, when I created
the APP or EXE the cursors can´t be update! I already excluded the tables
from my project, but nothing changes. Please answered me. Thanks for the
attention.

P.S.: Sorry for my english.

[Nancy Folsom]

"Rogerio Braudes" <rogeriobraudes@zipmail.com.br> wrote in message
news:39993fce$1@news.devx.com...
>
> Hello, I´m brazilian!

Hello!

> I want to know the solution of this problem.
> My cursors in the project, can be update succesfully! But, when I created
> the APP or EXE the cursors can´t be update! I already excluded the tables
> from my project, but nothing changes. Please answered me. Thanks for the
> attention.

Right click on the tables and make sure the tables are _not_ marked
included. If they are, they will be read-only.
>
> P.S.: Sorry for my english.

No need to apologize. It's great!

--

Nancy

Please post replies to the newsgroup
so everybody benefits from the
discussion.

Best viewed with a non-proportional font.

[McMalo]

hmmm.
I am not really sure.
But this looks like one of those VFP 'poltergeist' that I have seen in the
past.
Solution (to try):
1)Clean up everything as much as posible.
2)open the dbc as a dbf and packed (sounds weird, but the dbc is a dbf itself)
3)clean up the project (there is a option for that)
or
create a new empty project and put everything in again (good only if you
don't have 100 progs and forms)
4) Pray (at least it won't hurt)
I don't feel that I am really given a good solution, but who knows. I have
seen VFP do weird things because something was not completly clean.

[Nancy Folsom]

"McMalo" <McMalo@hotmail.com> wrote in message
news:3999800f$1@news.devx.com...
>
> hmmm.
> I am not really sure.

It's easy enough to check, you need to know how to. See below.

> But this looks like one of those VFP 'poltergeist' that I have seen in the
> past.

Doubtful.

> Solution (to try):
> 1)Clean up everything as much as posible.
> 2)open the dbc as a dbf and packed (sounds weird, but the dbc is a dbf
itself)

Yes, this is well-known. There is a also a command for doing this.
VALIDATED DATABASE [RECOVER]

> 3)clean up the project (there is a option for that)

That won't affect tables being read-only.

> or
> create a new empty project and put everything in again (good only if you
> don't have 100 progs and forms)

It is quite simple to recreate a project. Except in very unusual
circumstances, all you have to do is create a new project, add your main.prg
to it, and rebuild.

> I don't feel that I am really given a good solution, but who knows. I have
> seen VFP do weird things because something was not completly clean.

Unfortunately you don't mention the one thing I actually suggested...so it's
hard to go on.

Open your Project.
Choose the data tab
Expand the Database node
Look for circles with slashes thru them to the left of the table names. If
you don't see one, then the table has been included in your project,
therefore it's in your EXE, and therefore it's read-only. You indicated in
your original message that you had included your tables, but sometimes that
just means they are listed in the project. Please clarify this.

Other things that could be giving you trouble: your tables are marked
read-only in the OS, your network doesn't give write access to the files, or
your views are not correctly defined. The first thing to check is the
Included option for the tables.

[Nancy Folsom]

Correction:

"Nancy Folsom" <Nancy_Folsom@hotmail.com> wrote in message
news:3999900b$1@news.devx.com...

> VALIDATED DATABASE [RECOVER]

^

No "D"

VALIDATE DATABASE [RECOVER]

--

Nancy

Please post replies to the newsgroup
so everybody benefits from the
discussion.

Best viewed with a non-proportional font.

[Nancy Folsom]

McMalo (and Rogerio)-

"McMalo" <McMalo@hotmail.com> wrote in message
news:3999800f$1@news.devx.com...
>
> hmmm.
> I am not really sure.
> But this looks like one of those VFP 'poltergeist' that I have seen in the
> past.

I'm very sorry. I replied to you (message news:3999900b$1@news.devx.com...)
thinking you were Rogerio answering me. I had lost the context of your
post.

I apologize for any confusion this may have caused.

--

Nancy

Please post replies to the newsgroup
so everybody benefits from the
discussion.

Best viewed with a non-proportional font.

[Nancy Folsom]

Rogerio-

"Rogerio Braudes" <rogeriobraudes@zipmail.com.br> wrote in message
news:39993fce$1@news.devx.com...
>
> I want to know the solution of this problem.
> My cursors in the project, can be update succesfully! But, when I created
> the APP or EXE the cursors can´t be update! I already excluded the tables
> from my project, but nothing changes. Please answered me. Thanks for the
> attention.

I hated to think your problem got lost in the flurry of esoterica yesterday
<g>. Especially since I confused someone's post with being yours and read
you to say "included" and not "excluded". :-(

Did you find a solution ot your problem? If not, can you tell us more about
what the error is you get when you try to update your cursors?

How are you updating them? At what point to you get an error, and what is
the error?

For example, are you using TABLEUPDATE() or UPDATE SQL?

--

Nancy

Please post replies to the newsgroup
so everybody benefits from the
discussion.

Best viewed with a non-proportional font.