Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Separate databases for views and tables?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00266777
Message ID:
00266982
Views:
21
>Hi all,
>
>We are using Codebook framework with both pre- and runtime defined local views in the databases. It seems, however, that in multiuser environments our runtime defined views don't work so well because of collisions at the foundation time (which includes those not so funny 'database is used by someone else'-messages).
>
>So, we have decided to divide our databases into two parts - one (situated on the server) for tables and another one (situated in the workstation) for views. Because we have not succeeded to do our splitting so that Codebook framework would accept it nicely (even though it should be possible, in my opinion), we have found a potential trick. If we open the dbc as a table before using it and replace all dbc_name!tablename strings by a directory_name\tablename strings in property column of view and field records, everything seems to work perfectly. However, is that a right way to solve the situation or is there some other (safer) solutions available?
>
>Regards,
>
>Ilkka

Illka,

Your hack will work untill the user decides to move the tables DBC to another place. Other than that, it seems fine to me. There are several interesting subjects that are discussed in the wiki of www.foxforum Check http://www.stevenblack.com/wiki/wc.dll?wiki~CreatingDBCforViews first.

José
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform