Update Non Default Data Source

Archived Topics
1

Hi

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?

Thanks

Aidan

2

The code should be:fpmi.db.runUpdateQuery("UPDATE TBWorkOrder SET MachineID = 1 Where WorkOrderNumber = '1234567'", "TransOPT")

3

Hi Travis

That worked OK for me

Aidan