Skip navigation links

MySQL Forums :: DBF, dBASE, FoxPro, Clipper, xBASE :: Trying to update two remote views


Advanced Search

Trying to update two remote views
Posted by: Richard Stecenko ()
Date: February 27, 2010 03:44PM

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.

Options: ReplyQuote


Subject Views Written By Posted
Trying to update two remote views 3907 Richard Stecenko 02/27/2010 03:44PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.