Error SQL Update for SQL

Ignition
1

I try to update database when click button.
Nothing message "Error" and the weird thing is that yesterday it worked and when I tried again today, the update function did not work.

Script button :

	pic = self.getSibling("pic").props.text
	rootcause = self.getSibling("rootcause").props.text
	countermeasure = self.getSibling("countermeasure").props.text
	status = self.getSibling("status").props.value
	reponsedate = self.getSibling("responsedate").props.text
	defect_name = self.getSibling("defect_name").props.text
	
	system.db.runNamedQuery("Update_Report", {"pic": pic, "rootcause": rootcause, "countermeasure": countermeasure, "status": status, "reponsedate": reponsedate, "defect_name": defect_name})	
	system.perspective.closePopup('')

Named Query :

image
image1295×552 28.9 KB

And I tried to update data manual from SQL and success
image

I often have this problem when creating scripts on buttons (whether it's filters or data updates)

2

The one thing I can think of that would give you inconsistent behavior is if your defect_name could be different then what the defect_name is in the database. It looks like an entered field, so if a user entered 'BOCOOR' or 'BOCOR ' then your WHERE clause would not match a defect name and thus not update the record.

3

Your should capture the return value from system.db.runNamedQuery(). It gives the number of rows affected by the update. You can use that to provide feedback to the user.

4

Sorry my bad, this error solving by changed "reponsedate" from ":reponsedate" to be CURRENT_TIMESTAMP