database problem

[pancakeleh]

Hello i come across this problem when i am trying to delete info from my database. Screenshot here: ""[^] any solution?

[Lost User]

The message appears to be reaonably clear. It appears that you are trying to delete something but there is more than one row that matches and the DB does not know which one to delete.

Just say 'NO' to evaluated arguments for diadic functions! Ash

[pancakeleh]

meaning i have 2 attributes with the same values? however when i try to change it i am still unable to delete.

[TorstenH]

"no unique row" - don't you have an ID or another Key-Value in that db-table to identify the row? A ID is always a good thing, even if you barely use it. regards, Torsten

I never finish anyth...

[TorstenH]

you have 2 rows in your dataset table (not the GUI table!), which can not be clearly identified by the values you want to identify it with. example: row1 India Asia Delhi ... row2 India Asia Bombay ... You can not delete that one row with "India" and "Asia" as your database does not know which you meant. You can delete the row with "India" and "Bombay" or the row with "Asia" and "Bombay". This works, as it is clearly identified. regards, Torsten

I never finish anyth...

[Lost User]

Try posting this in the Database forum; I see nothing about Java here.

Just say 'NO' to evaluated arguments for diadic functions! Ash