Trying to update two remote views

[Richard Stecenko]

I have a VFP 9.0 application with ODBC to MySQL. There are is a table in MySQL. I have a remote view to that table. I added the view twice to the data environment of my form.

On the form, the user enters records into one of the remote views.

Before saving, I copy all the records into the other view and make some changes to the data in that view.

Then I try to update both views. I time out on the write.

I think this has something to do with persistent or non-persistent connections.

Can some one tell me which I should use with a VFP application, how to tell what kind of connection I have now, and how to change it if I have the other kind.