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

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

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

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

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