# \[SOLVED\] Deleting rows from a SQL table using RunPrepQuery

**URL:** <https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353>\
**Category:** Ignition\
**Created:** [February 17, 2020, 9:13pm UTC](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353 "2020-02-17T21:13:08Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![bmeyers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmeyers/32/37453_2.png) [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\
**Post date:** [February 17, 2020, 9:13pm UTC](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353/1 "2020-02-17T21:13:08Z")

</div>

I have some code here that lets the user drag and drop data from one power table to the next:

```
if system.gui.confirm("Are you sure you want to scrap this part?", "Recycle?"):
	if self != sourceTable:
		destDataset = self.getData()
		pyRowData = system.dataset.toPyDataSet(rowData)
		for row in pyRowData:
			newRow = []
			for column in row:
				newRow.append(column)
			destDataset = system.dataset.addRow(destDataset, dropIndexLocation, newRow)
		self.setData(destDataset)

		system.db.runPrepQuery("DELETE FROM my_Table WHERE RFID = ?;", [destDataset.getValueAt(0,0)])
		sourceTable = results
	else:
		system.gui.messageBox("Dropping on to same table not supported")

```

However it seems that no matter what syntax I try the sql table is never actually updated. Does anyone know what my runPrepQuery is missing?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [February 17, 2020, 9:25pm UTC](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353/2 "2020-02-17T21:25:22Z")

</div>

Try using [system.db.runPrepUpdate()](https://docs.inductiveautomation.com/display/DOC80/system.db.runPrepUpdate)

---

<div class="post-metadata">

**Author:** ![bmeyers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmeyers/32/37453_2.png) [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\
**Post date:** [February 18, 2020, 2:07am UTC](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353/3 "2020-02-18T02:07:27Z")

</div>

That worked thank you. Is there a way to also delete the row I copied into the destination power table?

```
newDataset = system.dataset.deleteRows(self.getData(), rows)
self.setData(newDataset)

```

The above isn’t cutting it…

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [February 18, 2020, 12:14pm UTC](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353/4 "2020-02-18T12:14:28Z")

</div>

Have you tried

```python
self.data = newDataset

```

---

<div class="post-metadata">

**Author:** ![bmeyers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmeyers/32/37453_2.png) [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\
**Post date:** [February 18, 2020, 5:13pm UTC](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353/5 "2020-02-18T17:13:50Z")

</div>

Yes, did not work.

---

<div class="post-metadata">

**Author:** ![bmeyers](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bmeyers/32/37453_2.png) [@bmeyers](https://forum.inductiveautomation.com/u/bmeyers)\
**Post date:** [February 18, 2020, 5:17pm UTC](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353/6 "2020-02-18T17:17:44Z")

</div>

```
self.data = system.dataset.deleteRow(self.data, 0)

```

This worked for me.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [February 18, 2020, 5:26pm UTC](https://forum.inductiveautomation.com/t/solved-deleting-rows-from-a-sql-table-using-runprepquery/32353/7 "2020-02-18T17:26:48Z")

</div>

Glad you got it sorted out! 🙂