Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Offline Views
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00210083
Message ID:
00210256
Views:
32
Thanks Josh. I assume that the DBC created on the users laptop harddrive still refers to the tables on the server and then the views are created and taken offline. Is this correct?

>Colin,
>
>I've probably never had more than a half-dozen users off-line at once. All of my views are created in code. When the user wants to take data offline the application creates a dbc on their laptop's hard drive and creates all the views in it. It then opens the views offline. When they come back it brings all the views back on line and updates them. I've never had a problem with multiple DBCs. Just make sure you don't modify the structures of your tables at all while users have off-line data. It will probably screw up the off line views and keep the users from udpating their data.
>
>>Josh,
>>
>>Interesting idea. I've always found the aspect that views can only be taken offline by one user at a time very limiting. I never thought of a multiple DBC approach. How many users were involved in your past experience and did you ever run into problems maintaining multiple DBC's? TIA
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform