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

Difficulties getting rows deleted from two different tables in Google Docs

I'm hoping that one of you would be willing to assist me. As will soon be painfully obvious, I am fairly new to Google Apps Script (and loops, for that matter, but I'm trying hard to learn). I hope my code will not make you cringe. Basically in…
3
votes
1 answer

EF Core > Delete entity (Soft Delete) > Entity State remains Unchanged

In my generic base repository I have the following simple method for removing an entity from database: public async Task DeleteAsync(TKey id) { var item = await Context.Set().FindAsync(id).ConfigureAwait(false); if…
Robert J.
  • 2,631
  • 8
  • 32
  • 59
3
votes
1 answer

Swift 2.0 .contextMenu Multiple Delete From Core Data

First time post in here and new to coding... so I hope I am following proper protocol. I am putting together a view in Xcode 12.2 (SwiftUI 2) that outputs a list of data from Core Data and have a context menu to provide the user the option to edit,…
Danz
  • 31
  • 2
3
votes
3 answers

Deleting row from Java ResultSet and not from underlying database

Is there a way in Java to delete a row just from a result set and not from underlying database? Thanks.
Prince Charming
  • 401
  • 4
  • 19
3
votes
4 answers

How to find index of a row based on the object value using C#?

I have a datagridview, and I want to remove a particular row from it (datagridview is not data bound). To remove, I need the index of the row. Datagridview items are all objects. At this moment, all I have is the id (a property) of the object. I…
nawfal
  • 70,104
  • 56
  • 326
  • 368
3
votes
1 answer

Is not deleting from bootstrap modal

as you can see these code, the deleting button inside of pagination works fine without bootstrap modal, and then convert to bootstrap model, the bootstrap model is working fine once click the delete button, but the problem is not deleting it or do…
Andy
  • 47
  • 3
3
votes
3 answers

How to delete rows that contain only certain values?

I have a dataframe like this column_name 0 OnePlus phones never fail to meet my expectatiion. 1 received earlier than expected for local set. 2 \n 3 good 4 must buy! 5 \t 6 7 awesome product! 8 \n I want…
3
votes
2 answers

How to select specific data in a dataframe and delete all other data?

I have a dataframe in which I have two columns; representing a group (data type: int64) & a date (data type: "0"). I would like to extract each subset of data per group with the oldest date until a new date is issued. All other rows of the groups…
Newbyy
  • 43
  • 4
3
votes
2 answers

remove specific words into a dataframe with pyspark

I have a DataFrame +------+--------------------+-----------------+---- | id| titulo |tipo | formacion | +------+--------------------+-----------------+---- |32084|A | Material | VION00001 TRADE | |32350|B …
3
votes
1 answer

Cassandra Delete when row not exists

Is there a performance impact when running delete statements on cassandra when row doesn't exist? I am not passing the IF EXISTS clause in my delete statement as it adds an overhead of checking. I haven't found anything online about this unique…
srvndr
  • 33
  • 4
3
votes
3 answers

Dynamicaly delet the table row using check box and javascript

How can we Dynamically delete the html table rows using javascript. We have a check box on each row. While clicking the remove button with the check box selected the row would be deleted. Such as document.getElementById(j).innerHTML = '';
Varada
  • 16,026
  • 13
  • 48
  • 69
3
votes
1 answer

Delete previous rows in Pandas Dataframe based on condition

I have a dataframe with user_id and some informations about them User_id type info 31 R*1005 no 31 R*10335 no 25 R*1005 no 25 R*243 no 25 R*4918 yes 25 R*9017 no 25 R*9015 no 46 …
3
votes
3 answers

Removing rows between two values in SAS

For the following data I am trying to filter rows, of each group ID, based on these conditions: After every row with type='B' and value='Y' do the following Remove the rows until the next row having type='F' and value='Y'. If there is no B='Y…
ckp
  • 579
  • 2
  • 10
  • 27
3
votes
1 answer

CRUD of Room in Java android, how to return the count of deleted rows from Dao and AsyncTask in Ripository through viewmodel back to CatalogActivity?

I am trying to develop this small app to do CRUD operations using Room, Repository, LiveData, and ViewModel and Listview, if you want to see development of the app or commit line of Java, here in this my github repository The original app which is…
3
votes
2 answers

SQL Delete with Join and Foreign Key constraint

Using 10.0.31-MariaDB-1~jessie. I have two tables: provider_contact and provider_contact_x_role where contact_id column in provider_contact_x_role table has a foreign key reference to id column in provider_contact table. When I run the following…
Suren Aznauryan
  • 984
  • 10
  • 24