Duplicate Primary Key

[Toni Epple]

Hello,

I'm trying to insert/update rows of a table via PERL ODBC. First I'm checking for presence of the row. If it's already there I'm updating one column, if not I'm inserting a new row.

That way I managed to insert rows with identical Primary Key combinations.

The table looks like this:

CREATE TABLE "USER"."SPHERES"
(
"CID" Char (16) ASCII,
"ASSAY" Boolean,
"SPHERE1" Long ASCII,
"SPHERE2" Long ASCII,
"SPHERE3" Long ASCII,
PRIMARY KEY ("CID", "ASSAY")
)

Performing this SQL-statement:
select * from SPHERES where CID = '1' and ASSAY=False
results in one row.

But Performing this SQL-statement:
select * from SPHERES where CID = '1' and ASSAY !=true
results in two rows with CID of '1' and ASSAY = False.

How can this happen?

regards

Toni



--

Anton Epple
Genomatix Software GmbH
Landsberger Strasse 6
D-80339 Muenchen

http://www.genomatix.de


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general