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
