Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi table update from a view
Message
From
30/10/2000 14:37:03
 
 
To
30/10/2000 14:20:39
Rex Mahel
Realm Software, Llc
Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00436010
Message ID:
00436029
Views:
28
>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.
Insanity: Doing the same thing over and over and expecting different results.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform