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 5985 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.