1,918 questions
-1
votes
0
answers
40
views
Deleting CosmosDB Record in python [duplicate]
I am trying to do a simple delete in CosmosDB but its saying that my partition key is incorrect.
# Initialize client
endpoint = cosmos_endpoint
key = cosmos_key
client = CosmosClient(endpoint, key)
...
- 1,051
0
votes
1
answer
131
views
Spring Data JPA @OneToOne Delete
I'm trying to delete a record from an entity with a one-to-one relationship without this deletion also deleting the record from the other entity.
@OneToOne
@JoinColumn(name = "order_id", ...
0
votes
1
answer
96
views
Delete ranges with openpyxl and adapt the relative references in formulae in the remaining cells
With openpyxl, when I use worksheet.move_range(range, rows=12, translate=True) the range will be moved 12 rows down. The translate=True will move the relative references in formulae in the range by ...
- 11
0
votes
0
answers
81
views
Cannot delete rows in Excel on the sheet or with VBA
I am creating a new worksheet and copying data from three others into it. Two of the worksheets have empty rows in them that get copied to the new sheet. After the copies, I sort the data to get the ...
- 17
0
votes
2
answers
61
views
How to delete a row if the text matches a certain color
I need to delete an entire row if the text is let's say the color green. I made a code, but it ends up deleting the entire sheet and if I change the range in the code to a certain range, the code only ...
1
vote
0
answers
56
views
How to remove an Arraylist row when it is not located in Main Activity
I have created an Arraylist of items. Once an item is selected, it goes to a new activity for the price to be calculated once the quantity is selected. Upon clicking cart, it goes to another activity ...
0
votes
2
answers
38
views
Deleting rows in mysql table that contain an empty field where more complete rows exist
I have a table which links the IDs of war memorials with the IDs of records of soldiers. It has a unique index based on the combination of the two IDs (sample data below).
I have recently started ...
- 582
0
votes
0
answers
38
views
Delete lines between "GOOD1 bad" and ";" [duplicate]
How can I use a sed command to find and delete the line starting with GOOD1 bad till the end of line (;) semicolon? Example:
Before
LUCK bad (
.abc(abc),
.bcd(bcd),
.def(def));
GOOD1 bad (
.abc(abc),
....
- 11
0
votes
1
answer
111
views
Office Script to delete rows older than today
I have a vehicle booking sheet in excel has column A as the date range. Currently I use macros to delete any rows that are older than Today() when the excel doc is opened to remove old data. We soon ...
0
votes
1
answer
124
views
Delete a specific value from one column and Rename another Value in Excel using office script
I need help on an ExcelScript where I need the Column J filter then
Delete the entire Row in column J with the value "Canceled"
Renamed any value in column J with "In Progress" to &...
0
votes
1
answer
218
views
My VBA code to delete rows works, but it is too slow
I have a VBA code that splits a large master file into several smaller sub-files, with each sub-file containing a portion of the original data. After splitting, the code is supposed to delete unwanted ...
- 74
-2
votes
2
answers
216
views
How to delete all rows hidden by user
Every end of the month I duplicate a tab with multiple hidden rows, then delete all those hidden rows from the duplicate tab. For that purpose I modified the following code of Tanaike, the code ...
- 22
3
votes
5
answers
205
views
How to delete row with max/min values
I have dataframe:
one N th
0 A 5 1
1 Z 17 0
2 A 16 0
3 B 9 1
4 B 17 0
5 B 117 1
6 XC 35 1
7 ...
- 47
0
votes
1
answer
1k
views
Supabase delete not working through javascript client api and postman
I'm trying to delete a row in a supabase table via the javascript client api (also tried postman later). Supabase is running on a remote server via docker. I'm working with Next.js, but all cache has ...
1
vote
1
answer
59
views
Delete from same table using inner join seems to be failing (both records removed)
I have a table which has both ChildID and ParentID. Due to the way the data was compiled, in some cases those values are reversed. So I wrote what I thought was a simple Inner Join where both values ...
- 515
0
votes
1
answer
235
views
Entity Framework Core v7+ : execute delete on foreign key related tables without navigation property
I have a following two tables each with millions of record so performance for delete is needed
Table Product
(
DateOf date not null,
Type varchar(100) not null,
ProductId int not null,
...
- 13
0
votes
0
answers
43
views
New to stored procedures; need help in creating procedure
I am new to procedures and trying to create a procedure to delete entries from tables.
Tables names will be in query 1. My request_id will be in another query which entries I need to delete.
How do I ...
- 1
0
votes
1
answer
74
views
Excel VBA: Filter and delete rows based on an array criteria range
I have the following code and am struggling to get it to work.
Sub FilterAndRemove()
Dim varDelItem As Variant
Dim lngRowStart As Long, _
lngRowLast As Long, _
...
- 15
0
votes
2
answers
128
views
How to delete a specific line containing a file path from a text file in Linux using a variable with this path? [duplicate]
I need to delete a specific line from the fstab file, given the Mountpoint in $MOUNTPOINT variable:
So, I have this variable:
MOUNTPOINT=/mnt/my_lvm_partition
when I tried to find it in fstab file:
...
- 99
0
votes
0
answers
50
views
VBA Delete Rows in sheet where formulas go to row 1000, then insert rows at bottom and copy formulas to new rows
I have a script that deletes rows based on a status cell in each row, then subsequently inserts new rows (same row count as those deleted) to the second to last row in the sheet. I am running into a ...
0
votes
1
answer
82
views
for issuing in cbt CLI 'cbt deleterow <rowkey>', how can i escape space character in a rowkey?
Please if anyone knows how to get succeeded on that :
I have to get rid of a set of rows in a bigtable. Their rowkey contains SPACE characters.
i am trying to escape those space characters but I´m ...
-1
votes
1
answer
63
views
Deleting lines in sheet based on text in one column in VBA
I currently have a macro set to delete lines I no longer need as a start:
Sub JSAidRun()
'
' JSAidRun Macro
'
'
Range("1:1,2:2").Select
Range("A2").Activate
Selection.Delete Shift:...
2
votes
2
answers
117
views
Delete all rows that contain a specific string if another string was found in any row of another column for that string in Excel VBA
Sorry if the question is a little hard to understand.
Basically I have a sheet with multiple columns and rows of data with headings like so:
A
B
C
data 1
type 2
BAD1
data 2
type 2
test
data 2
type 3
...
- 91
0
votes
1
answer
2k
views
How to Delete Multiple Rows in Power Apps Data Table
I have a Power Apps Data table and this data table retrieves my SharePoint list [Vacation Budget] records. I have already removed multiple records in the data table using the RemoveIf function based ...
- 27
1
vote
1
answer
61
views
Remove a portion of String after certain value
I am using below mentioned code for finding a string in a file(Constants.TcGVL), assign my desired value(%select%) to it and copy to a new location:
Call :ValueSubstitude "%root%\LeafSpring\...
- 11
0
votes
1
answer
149
views
Google sheets script is erasing formulas in columns I don't want deleted or cleared
I'm stuck in a very annoying situation, I have a script for google sheets we’re I have two sheets out of several others in the workbook, the script would email one sheet "Pedidos" as an ...
- 3
1
vote
1
answer
144
views
Sequelize destroy function not return instance of deleted row
exports.deleteCustomer = asyncHandler(async (req, res) => {
const id = req.params.id;
if (!id) {
res.status(400).send({ message: "can't remove ,invalid customer" });
...
0
votes
1
answer
59
views
Create Trigger Before Deleting A Row with Condition Postgresql
So for example I have this table
CREATE TABLE public."table" (
c1 int4 NOT NULL,
c2 int4 NOT NULL,
c3 int4 NOT NULL,
d varchar(20) NULL,
e varchar(20) NULL,
f date ...
0
votes
1
answer
77
views
Need to remove the last row of an IMPORTHTL function where the # of rows changes?
New to the sheets/excel squad and have hit a wall that stackoverflow / reddit / other forums doesn't seem to answer!
Short Story: **IMPORTHTML will pull a table based on changing criteria, which means ...
0
votes
1
answer
87
views
SwiftUI & CoreData: delete list item and leading label
I have a SidebarView within a NavigationSplitView. The SidebarView is a list of users with a leading label.
When I try to swipe-delete an user from that list an error is thrown in my SideBarLabel ...
- 3,142
0
votes
0
answers
280
views
Why does Excel VBA not delete rows?
I'm trying to delete excess rows from a sheet prior to printing and the following code does not work:
' Should be done!
Rows(firstRowTemplate + numHits & ":" & lastRow).Select '...
- 21
-1
votes
2
answers
93
views
Delete Row and Rename Worksheets From cell value
I've a list on the first worksheet cooresponding tot the worksheet name.
List is from 1 to ... and the name of worksheet is BT1, BT2, ....
Now Have I created a macro to delete a row from the list ande ...
1
vote
1
answer
79
views
Deleting rows in Oracle: evaluating vs. executing
When I run a DELETE command in Oracle, it does all of the should-I-delete-this-row evaluation before it performs any deletion, right? That's well-defined Oracle behavior, right?
For example, if I ...
- 493
0
votes
2
answers
70
views
How can I identify changes in stock in a pandas dataframe
I am working with a pandas data frame. This data frame has 3 important columns, one is AmountOfStock, which indicates the amount of available units, other is ProductType, which is the code of the ...
- 503
0
votes
1
answer
75
views
My mobile application crashes when deleting item
I am trying to develop a mobile application to get familiar with SQLite database. In here create, add methods are working. But when I am going to delete in list view the mobile app crashes. Here is ...
0
votes
1
answer
812
views
How to delete rows using Office Scripts based on dynamic column range in Excel?
I am working on a task in Excel using Office Scripts and I'm facing an issue with deleting rows based on a dynamic column range. Here's what I'm trying to achieve:
I want to delete entire rows below ...
- 19
-1
votes
2
answers
58
views
Single delete button for 4 listbox each in different pages
In this question, the coding that i have done seem to be not working when i run the vba and click the delete button nothing happen. I don't know which part it error because it does not show any error ...
- 1
0
votes
1
answer
289
views
Replicate delete note with alert confirmation in swiftUI as Notes app
I am trying to mimic the same behaviour that notes app does when deletes a note in swiftUI.
I have this code, but I am still missing the delete button to expand to cover the width of the cell.
import ...
- 1,293
1
vote
1
answer
41
views
sqlite delete code not working in database_handeler
db!!.rawQuery("DELETE FROM $Cards_TABLE WHERE $Card_Parent_Board_Id='$CardParnt_boardId' AND $Card_Parent_Swimlane_Id='$CardParnt_SwimlaneId' AND $Card_Parent_List_Id='$CardParnt_ListId' ", ...
- 31
0
votes
0
answers
71
views
Rows reappearing in Tables after Auto-Vacuum Failure in PostgreSQL on Windows
Version: PostgreSQL 10.21, compiled by Visual C++ build 1800, 64-bit
Platform: Windows
In our application code, we've implemented logic to clean up entries in several PostgreSQL tables using a loop. ...
0
votes
1
answer
86
views
Deleting CoreData object from a grouped (by Dictionaries) List in SwiftUI
I have an issue with Swipe to Delete on a grouped List in that it randomly deletes the wrong object. I understand that this comes from the (grouped) Lists index not matching the index of the object in ...
- 3
0
votes
2
answers
380
views
Delete duplicate rows using SQL and window function
In the following table
create table employee (emp_id integer, emp_name varchar(50), dept_id integer);
insert into employee values (1,'bob william',1);
insert into employee values (2,'scott tiger',1);
...
- 37
1
vote
1
answer
45
views
VBA for deleting rows of first duplicates among many duplicates
I am looking to write a VBA with the following steps:
Copy data from SheetA into SheetB
Deleting rows in SheetB using a reference column in SheetC
Sorting SheetB
Deleting rows of only first ...
- 11
2
votes
4
answers
4k
views
How to delete rows from Replicated&Distributed tables on Clickhouse?
I have a table which is a distributed table over replicated tables in Clickhouse.
Although I have tried different things I can not delete any rows from the table. What should I do?
Delete queries I ...
- 23
1
vote
3
answers
154
views
Delete Row based on Cell value in Multiple Sheet
I have a code to click button to delete row. But it only work for the sheet where the button being placed. (It well delete cell that contain text "Delete"). How to amend the code so that if ...
- 23
0
votes
1
answer
48
views
Delete a row in Sheet2 in Google Spreadsheets when a row in Sheet1 in deleted
When I manually delete certain row in Sheet1 I'd like to be able to automatically delete the next row in Sheet2.
I have a spreadsheet in my workplace where I use some data from Sheet1 in Sheet2 and ...
- 3
1
vote
2
answers
87
views
Delete all rows based on corresponding values in multiple columns
Edited question:
I would like to subset/filter a new dataframe based on multiple conditions. I tried the following code mentioned here (Subset data frame based on multiple conditions) and (Remove ...
- 169
0
votes
1
answer
438
views
Automatically delete a row in google sheets 30 days after a field is populated
I'm looking to automatically delete a row from a google sheet automatically after 30 days from a particular field being populated.
I.E. An employee is leaving the company, in the row, i want to ...
0
votes
2
answers
141
views
VBA Delete Row with Contain Text
I have prepared VBA code to delete row that contain word "Delete". The VBA is working but right now, I don't want the VBA to delete row number 8 even it wrote delete. Kindly assist.
Sub ...
- 23
0
votes
2
answers
168
views
prevent sharepoint deletion items by user creator
How can I prevent users from deleting sharepoint calendar list item, if the logged user is not the organizer or creator of the item? i need to prevent deletion items only if the logged user is the ...