[SOLVED] Deleting rows from a SQL table using RunPrepQuery

Ignition
1

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?

2

Try using system.db.runPrepUpdate()

2 Likes
3

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…

4

Have you tried

self.data = newDataset
5

Yes, did not work.

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

This worked for me.

1 Like
7

Glad you got it sorted out! :slight_smile: