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
( ) ( )
----------\ (----) /-----------
\__) (__/
