Use SQL On Mon, Feb 16, 2009 at 9:54 PM, Jon Liu <[email protected]> wrote:
> 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 - > > >
