Damon, AgingReport is not an updateable view. The only views that can be updated through SQL are views of a single table, without any GROUP BY functions or DISTINCT keywords.
You probably want to update one of the underlying tables, not the view. Bill On Tue, Feb 3, 2009 at 3:23 PM, Gray, Damon <[email protected]> wrote: > What am I doing here that constitutes "illegal access to table" ?? The > error is occurring on the "update" line. > > > > create temp view AgeingReport (CID, CNAME, INVOICE#, INVDATE, JOB, BAL, > AGEYR, AGEMO, AGE) AS + > > select DETAGE.CID, CLIENTS.CNAME, DETAGE.INVOICE#, 01/01/1900, "X", > DETAGE.BAL, DETAGE.AGEYR, DETAGE.AGEMO, DETAGE.AGE from DETAGE, CLIENTS > where DETAGE.CID = CLIENTS.CID > > > > update AgeingReport set INVDATE = INVDATE from RECAP rc, AgeingReport ar > where rc.INVOICE# = ar.INVOICE# > > > > wwwww > > ( @ @ ) > > -------oOO---(_)---OOo------- > > Damon J. Gray > > Anvil Corporation Business Services > > (360) 937-0770 > > oooo0 0oooo > > ( ) ( ) > > ----------\ (----) /----------- > > \__) (__/ > > >
