Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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,
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only