I have to write value to a cell in SQL table when a button is pressed in Igntion Screen.
I am trying to write SQL query in button’s actionperformed function using
queryValue = event.source.parent.getComponent(‘Numeric Label’).value
system.db.runUpdateQuery(“UPDATE TestDB SET ComponentRemQuantity = %s” % (queryValue), ‘SQLExpress’)
But this updates the value in all the rows of that particular column and i am not able to use a WHERE clause with this query also.
Am i doing something wrong or is there any other way to do this?
Thanks in Advance…!!