Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>What makes me nervous about this is: Does the view thus created correctly update the base tables? Are any special settings required to achieve this?
>
>I mean, if you vertically combine two tables, will VFP keep track of which table each record came from?
>
>Or can you only create R/O views safely, if you use UNION?
you have to define the PK field and source table. In fact it does not matter how the view got its contents. If you're writing data, if is checking if a records was update, deleted or inserted and uses the PK field and table settings in the view definition to cascade it to the underlying tables.
IOW, there is not neccesarely a direct relation between the SQL statement and the table which gets updated.
Walter,
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement