Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table Modifications not being seen at other workstations
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00355968
Message ID:
00356349
Views:
20
Thanks for the specifics, Larry. I remember when I was doing this 2+ years ago that I subclassed CtrApp and then changed SetUpTables, but I don't at this time remember the details.


>PMFJI, you don't have to comment out any code. You can subclass CtrApp and change the call in your application specific SetUpTables method to pass a .T. as the 2nd parameter to oLib.oDBCSvc.OpenData. This will tell the database service object to only open the database and not its contained tables.
>
>WRT the tables not refreshing, VMP sets REFRESH to 0,60 by default which means you have to wait 60 seconds before the memory buffered tables on your PC are updated with the latest data from the network. In my last app, 1 minute delays were unacceptable. I subclassed CtrApp and put the following code in my SetUpSets:
>
ctrapp::SetUpSets()
>
>set refresh to 0,12
>I used 12 seconds but you can make it any number you want. Remember, this command will increase network traffic the smaller the 2nd parameter, so you may have to do some experimenting to determine what is a good scenario for you.
>
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform