DELETE SQL with runPrepQuery return error

Ignition
1

Hi all
I have a problem with runPrepQueri when I use this command my SQL command is executed but returns an error.
What I doing wrong.
My code :

id = self.getSibling("Table").props.selection.data[0]['CarovyKod']
query = 'DELETE FROM RevizeRucNaradiSpotrebic WHERE CarovyKod = ?'
args = [id]
system.db.runPrepQuery(query,args)

And the error is here :

image
image1222×379 37.2 KB

2

What happens if you execute the query directly on the database using SSMS (SQL Server) or other database management tool?

The “Details” tab with “Full” selected will provide better clues as well.

3

Since it is a DELETE FROM query, I believe you need to user system.db.runPrepUpdate() insead.

4

Yes, thank you now it working without problems :smiley: