UPDATE SQL problem..
I am trying to update field F1 in table T1 with the results from a
summation query Q1. Q1 is most definitely not updateable. The update is
simply a join from T1 to Q1 on the primary key with only F1 in the
Access97 tells me the query must be updatable. Left-Joining T1 to Q1
does not help. I normally simply wrap this in a trx in code, but am
curious how to beat this seemingly simple operation.
SQL (noting that the query Q1 is non-updatable):
LEFT JOIN Q1
ON T1.PK = Q1.FK
T1.F1 = IIf([Q1.F2=0,True,False);
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL