General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
Thanks Trey,
That has been my experience also but I was wondering if someone knew this for a fact. My fear is that my assumption will come back to haunt me later. I think I'll have to go with Larry's suggestion unless I can get some more confirmation on this.
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