Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update order of views
Message
From
08/12/2000 12:02:32
 
 
To
08/12/2000 11:48:42
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00450829
Message ID:
00450836
Views:
26
>If you have a updateable view based on two tables (or n tables), is there any way to tell/force the order in which the tables are updated?

What I've seen is that it has to do with the order the tables were joined in the cursor. So if you have table1 join table2, table1 updates first, then table2. If you change the select to table2 join table1, table2 should be updated first, then table1.

In the select statement of a view into VFP data, you can include the FORCE argument to the FROM clause to force the join in the order you have specified.
You would have to create the view in code and not the view designer in order to do this.
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