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
