Hey, I'm deleting mannually through studio...so i do "show table data" and then select the rows I try to delete. I have tried setting the primary key as well and it doesn't have any affect on the current scenario...
Thanks Jon On Mon, Feb 16, 2009 at 8:20 AM, sallushan <[email protected]> wrote: > > Then Simply add one. > > I think: > The row you are deleting should be identified uniquely. Which means if > any other row exists in the table which contains the same data (i.e. > you cannot distinguish the 2 rows) then delete operation may NOT > occur. > > By the way how and from where you are trying to delete? > > On Feb 16, 8:40 pm, Jon Liu <[email protected]> wrote: > > There was, but when I had a problem inserting because the primaries were > all > > the same( i know..) so I unmarked the primary. So to answer your > question, > > no there is no longer a primary key... > > > > > > > > On Sun, Feb 15, 2009 at 10:17 PM, Arsalan Tamiz <[email protected]> > wrote: > > > Is there any primary key in the Table? > > > > > On Sun, Feb 15, 2009 at 11:55 PM, BigJ <[email protected]> wrote: > > > > >> I nserted some bad data into my table and want to remove it...when I > > >> try to delete the bad data this is the prompt that I recieve: > > > > >> Deleting data from existing tables: > > >> No rows were deleted > > > > >> A problem occurred attempting to delte row 4. > > >> Error Source: Microsoft.visualStudio.DataTools. > > >> Error Message: The row value(s) updated or deleted either do not make > > >> the row unique or they alter multiple rows(6 rows) > > > > >> Correct the errors and attempt to delete the row again or press @SC to > > >> cancel the change(s). > > > > >> Any thoughts? > > > > >> Thanks > > > > >> Jon- Hide quoted text - > > > > - Show quoted text -
