Try this. I think you need to reference the RECAP table for INVDATE update AgeingReport set INVDATE = rc.INVDATE from RECAP rc, AgeingReport ar where rc.INVOICE# = ar.INVOICE# Dan Goldberg
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Gray, Damon Sent: Tuesday, February 03, 2009 12:23 PM To: RBASE-L Mailing List Subject: [RBASE-L] - It's probably obvious, but... 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 ( ) ( ) ----------\ (----) /----------- \__) (__/
