Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
NOT EXISTS in an UPDATE statement |
Sun, Nov 4 2007 9:54 PM | Permanent Link |
Richard Harding | Hi Tim,
The NOT qualifier is being ignored in the following statement. UPDATE Stock SET flag = 'A' WHERE NOT EXISTS (SELECT * FROM StockOLD WHERE Stock.stocknumber= StockOld.stocknumber) I get the same results with the NOT present or absent. SELECT * FROM Stock WHERE NOT EXISTS (SELECT * FROM StockOLD WHERE Stock.stocknumber= StockOld.stocknumber) works OK. -- Richard Harding Windella Computer Knowhow 28 Freeman Drive Lochinvar NSW 2321 Phone: 61 2 4930 7336 Mobile: 0419 016 032 email: rharding@wck.com.au |
Mon, Nov 5 2007 1:32 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Richard,
<< The NOT qualifier is being ignored in the following statement. UPDATE Stock SET flag = 'A' WHERE NOT EXISTS (SELECT * FROM StockOLD WHERE Stock.stocknumber= StockOld.stocknumber) I get the same results with the NOT present or absent. >> Is this with the latest release/build ? If so, then could you send me the database catalog/tables ? We've got one report of something similar with NOT IN, but I want to make sure that it's the same thing before 1.06 goes out. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Nov 5 2007 4:04 PM | Permanent Link |
Richard Harding | Tim,
It is version 1.05 Build 2. Attached is the backup of the database. -- Richard Harding Windella Computer Knowhow 28 Freeman Drive Lochinvar NSW 2321 Phone: 61 2 4930 7336 Mobile: 0419 016 032 email: rharding@wck.com.au Attachments: CompareDB Backup On 2007-11-06.EDBBkp |
Mon, Nov 5 2007 4:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Richard,
<< Attached is the backup of the database. >> Thanks. In the future, if you could post these types of attachments in the Binaries newsgroup, I would appreciate it. Your attachment isn't huge, but I still try to not force lurkers to download attachements that they don't have any interest in seeing. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Nov 6 2007 4:23 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Richard,
Yep, it's a bug and will be fixed in 1.06. The NOT is getting negated during the compilation, thus giving the results that you're seeing. This is also an issue with DELETE queries, but as you noticed, not SELECT queries. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 09:18 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |