Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi table update from a view
Message
From
30/10/2000 14:57:47
Rex Mahel
Realm Software, Llc
Ohio, United States
 
 
To
30/10/2000 14:37:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00436010
Message ID:
00436046
Views:
18
Trey,

They are...It doens't!

Any other ideas?

Rex

>>All,
>>
>>OK, here an easy one.
>>
>>I have a complicated multi table view which I want to update multiple tables. I have the record loaded, but the only base table that gets updated is the first table in the FROM clause.
>>
>>Can I do this?
>>How?
>>What am I doing wrong?
>>
>>TIA
>>
>>Rex
>
>The Key field for all tables (usu. primary key) being updated must be in the view and marked as a key field.
>That ought to do it.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform