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
0
votes
1 answer

VBA Delete entire row if value is less than specified value - deletes wrong rows

I'm attempting to run a small macro that searches column S of a worksheet and if the value in column S is <0.501, it deletes that row. The code I am running at the moment deletes some rows but appears to do so randomly rather than based on the cell…
squar_o
  • 557
  • 2
  • 11
  • 36
0
votes
1 answer

How to delete data as rowwise in gridview when the page load occur in asp.net c#?

I want to delete the data from the Grid and when I insert the new data it should be display in grid.This should happen when the page load occurs.I tried this code. protected void Page_Load(object sender, EventArgs e) { …
Kevin Andrid
  • 1,963
  • 1
  • 15
  • 26
0
votes
2 answers

Compare two worksheets, find first match and paste, then delete source row

I have two worksheets and want to paste two cells from the second worksheet (Sheet1) when find the first match in active sheet. Then delete the source row in Sheet1. I can't loop from the last row of the active sheet because I want to populate the…
LuigiX
  • 1
  • 1
0
votes
2 answers

Delete Row and Save DataGridView

I haven't done too much with DataGridViews in C# form applications so my approach is a rookie one I'm sure. Any help would be awesome! My form is displaying the DataGridView for my database, and I want to give the user the option of deleting a…
Cory Hull
  • 31
  • 5
0
votes
2 answers

Deleting row from table and database PHP/MySQL via image button

I am trying to call a function within a php file that will fire a query to delete a row from a table and the database but can't seem to get it working here is the button:
Peter Connolly
  • 7
  • 6
0
votes
1 answer

SQL Delete after a different date for each ID

I am performing a conversion analysis that only needs to look at activity up to the first conversion for each User_ID. I can find the time of the first conversion for each user with this query: select min([Time]), [User_ID] from [Table_1] where…
Mike Brinkman
  • 3
  • 1
0
votes
1 answer

PDO- Delete entire row

I'm trying to delete an entire row in a database table. Here I want to delete the row if $token and $user_id is matched.But my code is not working. db_connection->prepare("DELETE FROM rt_strings WHERE rt_string =…
smc
  • 205
  • 2
  • 10
0
votes
3 answers

SQL Delete with relation to another table

I have two tables, for example: TableA with columns GUID,ProgKey,UserKey,ProgName. TableB with columns GUID,AppKey,ModeName. Foreign Key: GUID->TableA.GUID I need to delete TableB.AppKey with specific value but only with the condition where…
CodeGust
  • 831
  • 3
  • 15
  • 36
0
votes
0 answers

Matlab File does not run properly

I don't understand what the errors mean... I was trying to have my code read my text file starting at line 20, and from there, remove any NaN that is found... I'm not sure if I'm taking the right approach or not... fid = fopen('RS1102G1.txt'); Rows…
thewildone26
  • 11
  • 3
0
votes
1 answer

How to delete row from table without delete a row from referenced table?

When I try to delete a row from table company_catalog I want to not delete the data from the referenced table store_catalog. Constraint in table store_catalog with on delete no action, but server return…
badCoder
  • 111
  • 1
  • 16
0
votes
0 answers

Delete All Rows in SQL Table on Page Load

I am loading data from an excel sheet into a SQL table and then joining that data to another table with a script. On Page Load of my program I would like to delete all rows from my "temp" table. I am currently doing this, but it is not working at…
codeFinatic
  • 171
  • 1
  • 5
  • 18
0
votes
1 answer

tsql delete row very slow

I have a table with different articles. The article has two states: new enabled The user can only order articles, who are enabled. The user also can delete new articles. And here is the problem, it tooks too long the delete a 'new' article. It's…
wydy
  • 71
  • 12
0
votes
1 answer

mysql - deleting large number of rows with a limit (php nightly cron)

Not sure what the best way to handle this is. For my particular situation I have numerous tables where I want to delete any rows with a timestamp that is greater than 3 months ago... aka only keep records for the last 3 months. Very simply it would…
user756659
  • 3,372
  • 13
  • 55
  • 110
0
votes
1 answer

sql tables have some 'recursive constraint'. Can not delete row

In Sql server, I have 2 tables A and B table A has foreign key ID references B.Id -> I can not delete row in table B before row in table A (with same Id) and table A has trigger so that with every Id in table B, table A has least 1 row same Id , so…
Stevie
  • 3
  • 1
  • 2
0
votes
1 answer

Scala SQLite Invalid Query for DELETE

I have problem when trying to add a row and then delete one row from a table. What I have now is: def addItem(item:Item)={ val query = items.filter(_.name === name) items += (item.name,item.timestamp) if(query.list.length…
Ou Tsei
  • 470
  • 7
  • 24
1 2 3
…
99
100