Stack Overflow
Stack Overflow

Questions tagged [rowdeleting]

91 questions
6
votes
3 answers

Delete all records that have no foreign key constraints

I have a SQL 2005 table with millions of rows in it that is being hit by users all day and night. This table is referenced by 20 or so other tables that have foreign key constraints. What I am needing to do on a regular basis is delete all records…
Rodney Burton
  • 427
  • 8
  • 18
3
votes
3 answers

Keep only the last 5 rows per object in an audit table

I have a web application backed by a Postgres (v11) database and a main table where each row in the table may be seen as an object and each column is a field of the object. So we have: | id | name | field1 | field2| .... | field…
navinpai
  • 955
  • 11
  • 33
3
votes
3 answers

Deleting rows with duplicate info in columns

I'm writing a code that copies data from one sheet into another and I've got that function working fine. Now, I'm trying to code it to delete any rows that contain duplicate information based off that information's ID number in column F. Part of…
Tommy M
  • 33
  • 3
3
votes
2 answers

Deleting a selected item on ListView in javafx

I have an ListView with items, and developed a delete function which deletes the item. The problem Im facing is when I delete an item, the item below gets deleted as well. To give you a better understanding. ex: If I have 5 items in a list and I…
Java Gamer
  • 567
  • 3
  • 9
  • 24
2
votes
1 answer

Sorting and deleting rows. Run-time error '13': Type mismatch

I tried to work with macros that should sort p-values in column H delete all the rows with p-values >=0.05 fill column I with "B - E", I mean I2=B2-E2; I3=B3-E3 et cetera sort by column I This macros was created by Jeeped: Sub sort1() Dim m As…
Екатерина Самойлова
  • 21
  • 1
2
votes
1 answer

How to Delete the first 10 and last 10 rows of a SAS Data file?

I am trying to delete the first ten and last ten of a SAS data file But I am not able to do this. By using the code below I am able to delete the last 10 rows but not the first 10. data b; set a NOBS=COUNT; if count <= 10 then delete; if count…
David Chris
  • 255
  • 4
  • 16
2
votes
3 answers

How to delete rows with a unique ID from a panel data frame in R?

I have a data table containing thousands of firms that can be identified by a unique ID. It is long format data and each firm is supposed to appear twice in different years (cross-sectional time-series over two years). However, not all firms appear…
M_R_
  • 35
  • 4
2
votes
2 answers

Deleting unnecessary rows after column shuffling in a data frame in R

I have a data frame as below. The Status of each ID recorded in different time points. 0 means the person is alive and 1 means dead. ID Status 1 0 1 0 1 1 2 0 2 0 2 0 3 0 3 0 3 0 3 1 I want to shuffle the column…
Slouei
  • 716
  • 7
  • 19
2
votes
2 answers

GridView PreRender not firing after RowDeleted

When deleting a GridView row in the UI (via a LinkButton whose CommandName="Delete"), the view does not automatically refresh and continues to display the deleted row until I take some other action (manually refresh page, navigate away and back…
GISmatters
  • 431
  • 8
  • 20
1
vote
2 answers

Properly deleting an item from UITableView

Could anybody please explain how to properly implement the tableView:commitEditingStyle:forRowAtIndexPath: method so that I could properly delete an item from the backing array and display only the items that I haven't deleted yet? Here's what I…
nemesis
  • 1,349
  • 1
  • 15
  • 30
1
vote
1 answer

Gridview CommandField validation works, but not firing Delete method

I have a gridview that I'm trying to validate from code behind. In this case, to confirm a record deletion. My deletion method works fine until I add the validation which, when I implement it, it doesn't fire the deletion. To be clear, the deletion…
John Kinane
  • 366
  • 2
  • 8
  • 17
1
vote
1 answer

After deleting a record in Rails 3, the refreshed view isn't updated

I'm dealing with a basic one to many relation where I'm deleting a record on the many side. The models are "places" and "search_terms" where places has_many search_terms. When I create a new record, the view is updated and the new search_term…
Gerard
  • 4,818
  • 5
  • 51
  • 80
1
vote
2 answers

Google Apps Script & React.js : DELETE https://mygoogleappapi.com/exec 405 (Method Not Allowed)

Thank you for reading! I am learning how to use GAS now, I can't delete the specific row I selected on google spread sheet. I got the theme error after trying to delete using "axios.delete method" when I used react app and google script api. I…
takuma bo
  • 194
  • 2
  • 10
1
vote
4 answers

How to delete observations based on changes in specific variable?

I have a balanced panel data table containing thousands of firms with observations in two years each (1 & 2). For the data cleaning process I need to exclude observations where there is a shift between the years in a supposedly time-constant…
M_R_
  • 35
  • 4
1
vote
1 answer

Datagridview row data deletion Query code doesnt work correctly

I can able to delete rows from datagridview but cant in sql tables with query code. So basically my 'string query ' code gives an error. https://i.stack.imgur.com/btrYT.jpg https://i.stack.imgur.com/aezx8.jpg private void removebtn_Click(object…
phybarin
  • 81
  • 1
  • 11
1
2 3 4 5 6 7