Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Separate databases for views and tables?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Separate databases for views and tables?
Divers
Thread ID:
00266777
Message ID:
00266777
Vues:
57
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
Ilkka Koskinen
Tel : +358 40 729 3530
Fax : +358 9 3920 7210
Email: Ilkka.Koskinen@tietoenator.com
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform