Add row to table in SQL Database

[OscarLucas]

Hello All, i was reading all the post. And i arrive to one new error. I can’t found the way to solve. Can you help me?
My code
value1 = event.source.parent.getComponent(‘Text Field’).text
value2 = event.source.parent.getComponent(‘Text Field 1’).text
value3 = event.source.parent.getComponent(‘Numeric Text Field user’).intValue
value4 = event.source.parent.getComponent(‘Numeric Text Field station’).intValue

table = event.source.parent.getComponent(‘Power Table’)

insertQuery = “INSERT INTO tasks (task_name, task_description, user_id, station_number) VALUES (’%s’, ‘%s’, %d, %d)”
args = [value1, value2, value3, value4]

Insert the record in the database table

system.db.runPrepUpdate(insertQuery, args, database=‘DB’)

Refresh the table data

system.db.refresh(table, “data”)

My error

[Gaurav.Shitole]

@OscarLucas

insertQuery = “INSERT INTO tasks (task_name, task_description, user_id, station_number) VALUES (’%s’, ‘%s’, %d, %d)”

@OscarLucas Try it this way,

"INSERT INTO tasks (task_name, task_description, user_id, station_number) VALUES (?,?,?,?)”

[OscarLucas]

done