Stack Overflow
Stack Overflow

Questions tagged [delete-row]

Delete row refers to the removal of rows from a relational database.

The deletion can be achieved by using the DELETE statement of the SQL language.

1917 questions
3
votes
2 answers

Use UITableViewCellDeleteConfirmationControl to know what is the current cell's subview

Is it OK to use UITableViewCellDeleteConfirmationControl this way: - (void)layoutSubviews { [super layoutSubviews]; [UIView beginAnimations:nil context:NULL]; [UIView setAnimationBeginsFromCurrentState:YES]; [UIView…
oridahan
  • 574
  • 1
  • 7
  • 20
3
votes
1 answer

How to delete rows from UITableView with animation?

I am having problems with deleting rows from table view. I am using the code below when the delete button in the row was pressed: NSIndexPath *indexPath = [NSIndexPath indexPathForRow:control.tag-100 inSection:0]; [resultList…
Burak
  • 5,706
  • 20
  • 70
  • 110
3
votes
1 answer

Deleting Row with multiple WHERE in SQLite Android

Is this the correct way to delete rows with Multiple WHERE arguments? I am trying to make it as safe as I can to the database query. db.delete(TABLE, NAME + "=? and " + ID + "=? and " + ARG3 + "=?", new String[] { myName, x, argument3 }); Also is…
Jaiesh_bhai
  • 1,778
  • 8
  • 26
  • 41
3
votes
4 answers

How to Delete duplicate rows without Primary key

The following table has no primary key, I would like to delete the duplicate rows from the following table. The only differentiating factor in the duplicate rows is atom_id2. How do I delete that duplicate row. Please do give your…
navin
  • 384
  • 2
  • 4
  • 15
3
votes
4 answers

perl to delete consecutive duplicate lines

I want to delete the consecutive duplicate lines. i.e. for example **test.txt** car speed is good bike slower than car plane super fast super fast bullet train super fast This removes all the duplicate lines except the 1st occurance. perl -ne…
chinmoy khaund
  • 119
  • 8
3
votes
2 answers

MySql, after DELETE update a counter to contain no gaps

I have a mySql table like this (simplified) Id*| Text | Pos (integer) ----------- A | foo | 0 B | bar | 1 C | baz | 2 D | qux | 3 Now, after I delete a row, I want to update the Pos value on the remaining rows so that no "holes" or…
Muleskinner
  • 14,150
  • 19
  • 58
  • 79
3
votes
3 answers

Excel VBA - If cell is an integer, delete the entire row

I have been trying to use some snippets on how to delete entire rows on Excel VBA, but I can't modify them to include the "IsNumber" verification. I need to be able to choose an active area, like: Set r = ActiveSheet.Range("A1:C10") And as it goes…
tracer
  • 63
  • 1
  • 6
3
votes
2 answers

Oracle Compound trigger - how to store and "use" deleted rows? INDEX BY table?

I am fighting a long struggle now for a DELETE trigger in Oracle, which, upon deleting a line, selects a new MAX value from the remaining rows and writes it to another table. After stumbling across the annoying ORA-04091 mutating table error (can't…
Erik Hart
  • 1,114
  • 1
  • 13
  • 28
3
votes
5 answers

SQL delete from related tables

I am trying to delete all records that match a quiz id from the question table and the relationship table. The query works for a select statement, but won't allow the same statement to delete. @quizId is a quiz Id value I pass into my stored…
Bryan
  • 17,201
  • 24
  • 97
  • 123
3
votes
1 answer

mysqli DELETE ahref not functioning

I have a Delete link listed beside all $rows, when I mouse over them they reflect the correct id for deletion, however, when I click DELETE I get redirected to phpfile.php?id=4, for example, and nothing is deleted, no errors are posted. while ($row…
V1GG3N
  • 309
  • 1
  • 6
  • 22
3
votes
3 answers

XCode - Objective C: Deleting Table row crash

Welcome! I just spent the entire morning working on this, but no banana; maybe you have an insight! I am working with a standard NSMutableArray: self.itemTable = [[NSMutableArray alloc] initWithObjects:@"House.", …
MikeDaMike
  • 63
  • 1
  • 5
2
votes
2 answers

How to delete certain rows from Access via Delphi?

while not TBLOrder.Eof do begin TBLOrder.Locate('OrderID', Total, []); TBLOrder.Delete; end; This just deletes every single row in my Access Database, which is really annoying. I'm trying to get the program to delete the selected row (which is…
Craig
  • 675
  • 1
  • 7
  • 23
2
votes
2 answers

How to automatically limit the number of rows in a database?

I have the following table +-----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+------------------+------+-----+---------+----------------+ |…
Riki Lyng
  • 317
  • 4
  • 19
2
votes
1 answer

SQL Delete TOP statement

my table (sql sever 2000) contains large amount of rows, when i delete row, it extremely slow. i saw some post/forum that suggest to use a WHILE loop function to delete record by batch. my sql is: DELETE FROM Tprs_master where Fincmonth='201109'; I…
Joe Yan
  • 2,025
  • 8
  • 43
  • 62
2
votes
2 answers

Is there a VBA code to delete all rows after the last row which contains data?

I have an Excel table with data in columns A:Y. Columns A:G will always contain values, while columns H:Y MAY NOT contain values. I would like to 1) sort my table based on based on column "H" which will move the rows containing blanks to the bottom,…
Bill
  • 51
  • 5
1 2 3
…
99 100