Check out correlated sub select in the docs for what is going on. Only one table is in the sub-select, and refers outside the parens for the match.
The message indicates that APPEND doesn't like the statement for some reason or other. Interesting. Here is way to do this: PROJECT TEMPORARY NewEntries + FROM genWaste WHERE Shipped = 0 AND ID NOT IN + (SELECT id FROM WasteChoose) APPEND NewEntries TO wastechoose DROP TABLE NewEntries > [EMAIL PROTECTED] wrote: >I am not sure what the difference is between my t1,t2 correlation and your >version BUT I do get the following error message when your version executes: > >-ERROR- Cannot do this command on a view. > >Very interesting, considering that neither GenWaste or WasteChoose are views >- they're tables! > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Monday, June 02, 2003 4:14 PM >To: [EMAIL PROTECTED] >Subject: [RBASE-L] - RE: APPEND different in form EEPs vs. R> ? RBW6.5++ >(latest build) > > >One of those cases where APPEND will do something that INSERT will not: use >the destination table in the where clause. �Perhaps a correlated sub-select >would work. > >APPEND genwaste TO wastechoose + > �WHERE shipped = 0 AND id NOT IN + > �(SELECT id FROM wastechoose WHERE id = GenWaste.id) > > >>The following code gives different results if run in a form EEP vs. run >>from a standalone command file/R> : >> >>APPEND genwaste TO wastechoose WHERE shipped = 0 AND id NOT IN (SELECT >>id FROM + >> � genwaste t1, wastechoose t2 WHERE t1.id = t2.id) >> >>If run on its own, the first time, it adds the expected 55 rows; the >>second and subsequent times it appends no rows unless shipped has >>changed to = 1 for a particular id. >> >>If run in the form EEP, it keeps appending the entire 55 rows each time >>the EEP is run. It appears to be ignoring the NOT IN condition. >> >>Is APPEND one of those commands that doesn't/shouldn't work in an EEP? >> >>I have run this thing to death and am not seeing any obvious >>differences other than APPEND not working the same. >> >>Thanks, >> >>Charles Sikora >>Coordinator, Gas Storage >>Manlove Field >>Peoples Energy Corporation >>(217)-897-7123 >> >> > > >-- >Albert Berry >Full Time Consultant to >PSD Solutions >350 West Hubbard, Suite 210 >Chicago, IL 60610 >312-828-9253 Ext. 32 > > >__________________________________________________________________ >McAfee VirusScan Online from the Netscape Network. Comprehensive protection >for your entire computer. Get your free trial today! >http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 > >Get AOL Instant Messenger 5.1 free of charge. �Download Now! >http://aim.aol.com/aimnew/Aim/register.adp?promo=380455 > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
