Hello,

I have a table where the following SELECT statement yield
different results:

a) select kontrollsumme
from buchhaltung
where zeile+1=1232
--> result set contains two rows even though
"zeile" has a primary key constraint

b) select kontrollsumme
from buchhaltung
where zeile=1231
--> result set is correct

Any ideas? Is this database corrupt?

Cheers,
Tobias

-----------------------
Tobias Giesen, Composer
Developer of TGTools
www.tobiasgiesen.de
www.tgtools.com
-----------------------