Visual FoxPro Remote view

5 pts.
Tags:
SQL
SQL migration
Visual FoxPro
Currently I'm doing SQL migration through remote view to my new product. In this, how to handle the following case. Single application will be access by each user and SQL DB in common server. Remote view [dbc] also common to all users. When one user add one record to a master table, how the changes will reflect to other user? Also we are having the navigation tool bar. In this, if the user select Next or Previous how to refresh the remote view records for the changes done by other user? We can not call Rebury() at navigation level as every navigation selection system will try to refresh the view which will reduce the performance. Help me, how to handle this efficient way.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    If I understand, if another user adds/updates a record in the master table, you want any other user that navigates to a page with that data to show the updated data without doing a refresh?? I don't think that's possible. Are you building the data a page at a time or downloading the entire database? Building it one page at a time should not have a major impact on performance.
    82,620 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: