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
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