Greetings. I have a flex container that I'll run in an embedded view for our users in our dis-assembly process. Currently when we register a defective part we take to a hold area for a user to determine what parts are scrapped; What parts are ok to use again and what parts weren't affected (Never made it on the part). I've created a table with boolean values that I'm able to change by clicking to determine what's scrap/return/etc.. There's a column in this table called "indx" which is the incident log value that's unique each time a defect is logged. I'm using this indx value in the runPrepUpdate. When I write this in SSMS it works fine, when I write it in the runPrepUpdate it's not working correctly at all. It's trying to pull values from a table instead of a drop down.
Screen:
Script:
ind=self.getSibling("Dropdown").props.value
x=self.getSibling("Dropdown").props.options
query="insert into assy_scrap_logging (component,qty,[action]) SELECT component,qty,'scrap'
from ASSY_Scrap_Journal where indx = ? and scrap = '1'"
system.db.runPrepUpdate(query,(ind))
Error I'm getting:
As always any help is greatly appreciated! Thanks in Advance!