cursoradapter and mysql

[r***@home.nl]

Hi,

i'm new to using cursoradapters but it seems like it's very usefull. I
tried a simple form, using a cursoradapter. I set up properties with an
ODBC data source, on the auto update tab i selected the auto update
option and in advanced and refresh i also selected my ODBC connection.

When using this cursor on my form, everything works nice BUT the
update. It doesn't update anything?

What is it that I overlook?

Thank you!

Rotsj

[Jack Jackson]

Post by r***@home.nl
Hi,
i'm new to using cursoradapters but it seems like it's very usefull. I
tried a simple form, using a cursoradapter. I set up properties with an
ODBC data source, on the auto update tab i selected the auto update
option and in advanced and refresh i also selected my ODBC connection.
When using this cursor on my form, everything works nice BUT the
update. It doesn't update anything?
What is it that I overlook?
Thank you!
Rotsj

There are several properties you need to set to allow updates and
deletes to work, like KeyFieldList.

See the topic in Help: Data Access Management Using CursorAdapters

[r***@home.nl]

Post by Jack Jackson

Post by r***@home.nl
Hi,
i'm new to using cursoradapters but it seems like it's very usefull. I
tried a simple form, using a cursoradapter. I set up properties with an
ODBC data source, on the auto update tab i selected the auto update
option and in advanced and refresh i also selected my ODBC connection.
When using this cursor on my form, everything works nice BUT the
update. It doesn't update anything?
What is it that I overlook?
Thank you!
Rotsj

There are several properties you need to set to allow updates and
deletes to work, like KeyFieldList.
See the topic in Help: Data Access Management Using CursorAdapters

Hi,

thank you for your reply. The settings in VFP were OK. I used a mysql
view with a join. A join is a view will makes it non updatable.