can we update views without affecting master tables
-
i have created one view on four tables .Now i want view to be updating but not the master....if it cant be done...can u tell me the way to get such problem solved??
-
Since the view shows data from the base tables it naturally cannot be updated without modifying the base tables. There is no solution for that. But what do you really need to do here? Why do you need to update the view? Could you not simply create a table and copy the data from the other four tables into it as a one-time thing. Then you can update this new table without changing the other tables.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply