Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Backlinks
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00200887
Message ID:
00200912
Vues:
9
>We have a DBC which contains a table with validations. Our application clones this table, the result of which is used for dataentry. We need to have multiple clones with unique names which possess the same validations as the original table.
>
>When we create the new table, we create the backlink. My question is this: Are we limited to only 1 active link to a table with the same validations?
>
>After opening one table with the backlink, if I subsequently open another table (of the same clone type) I need to backlink that one as well - even if it is the original table.
>
>Thanks much,
>Nancy

You are linking these clones to the DBC? Then, when finished, are the clones deleted/removed from the DBC? Why not just create a single updatable sql view of the table and use private datasessions? This allows you to have multiple instances of the sql view open in the same VFP session without having to track temp file names, etc. A sql view honors validations, and has all the advantages you may be desiring in your cloned tables. If necessary, views can be opened with no data. The view can be parameterized to select a specific set of records. You can take advantage of the View Designer to create this. A code example with a parameter [e.g., ?lcValue]:
create sql view myview as select <i>field_list</i> from mytable ;
   where somefield like ?lcValue order by ...
You would pass the parameter [lcValue] as something like "Smi%" to retrieve all records whose fieldname starts with Smi.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform