I am having some problems with an update script that is updating a database table that is not in the Default data source. The script is been run from an action performed of a button. I get an error while executing saying that there is a spelling error with the data source.
This is what I have tried but it is not working
fpmi.db.runUpdateQuery("UPDATE TBWorkOrder SET MachineID = 1 Where WorkOrderNumber = ‘1234567’ "),[TransOPT]
Am I using the correct syntax for an update to the non default data source?