why is my delete statement complaining of duplicates?

[matpj]

I have a query that is simply just a delete statement from one of my tables.

when I run it, I get the message:
"Single-row update/delete affected more than one row of a linked table. Unique index contains duplicate values"

why would a delete statement complain of this?
the table is linked from an Oracle database.
Sometimes the delete query works, but after I use an external application to insert records and then try to delete I get the error above.

 

[Crowley16]

somehow your delete operation IF successful would create duplicate records in a field that doesn't allow it...

are you sure that you are deleting the record and not updating?
Also, are you sure that you're deleting the entire record, and not just a part of the record?

maybe if you post the sql ur using...

 

[matpj]

my SQL is:

delete * from <table name>;

 

[amorous]

Here is the thing:

delete * from <table name>; works only for Access Databases
and not for any other DBMS...

So you try this:

delete from <table name>;

without a *


-VJ

 

[matpj]

I did also try that at one point, but it displayed the same message.