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
