> One of those cases where APPEND will do something that INSERT will not: use the destination table in the where clause
Now that I didn't know (one of very many things, I hasten to add) - and it's a useful thing to know, thanks Albert. Regards, Alastair. ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, June 02, 2003 10:13 PM 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 >
