var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: When a view is updatable and when is non?
I've found out experimentally, that a view is updatable when it doesn't contain:
3. GROUP BY
When a view contains JOIN, it's needed to find out by trying to update.
Does anyone know the accurate list when a view is updatable?
(I use VB6 with MSSQL2000 (2005, 2008 must support) through ADO2.8)
Thanks in advance.
Take a look at the remarks section here:
CREATE VIEW (T-SQL)
Views with UNION ALL can be updateable. UNION DISTINCT can't.
Originally Posted by sv2k
Views with subqueries can also be updated.
There are defferencies from Access-SQL behavior.
I'll try to update in each case the recordsets to find out exactly.