I’m trying to delete via prepared statments but I have a problem:
when I execute this statement (without prepared statement):
system.db.runUpdateQuery("delete from TABLE where COLUMNX = 15.4 ")
it returns me 1 indicating that I have deleted a line. It’s ok.
In the same preconditions, when I try with the prepared statement like that:
system.db.runPrepUpdate("delete from TABLE where COLUMNX = ? ", [15.4])
the statement returns 0 to me and it hasn’t deleted anything.
what am I doing wrong?