Any ideas why this statement makes a query not updateable?

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have worked through my whole query and found that this is the
specific clauses that causes the problem. I have read some comments
that subselects automatically make a query non updateable but other
people post that they work. Any suggestions what I might be able to do
to get this to work. I do not need to update info in the CTAM tables
just the ParentAccounts table.

(iif((Select Count(*) From CTAM Where
CTAM.intParentID=ParentAccounts.intParentID AND
DateDiff('d',CTAM.Createddate,Now()) < 90)=0,0,-1)) AS OnCTAM

ParentAccounts.intParentID is the primary key
CTAM.intParentID is not the primary key for that table but it is
Indexed

Any insite would be appreciated.

Thanks
 
In JET, a subquery in the SELECT clause makes the query non-updatable, but
you can use one in the WHERE clause without losing the updatability of the
query.
 
Back
Top