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
Wed Aug 04, 2010 6:34 am
Travis.Cox
Moderator
Joined: Sun Apr 02, 2006 2:46 pm Posts: 1975 Location: Sacramento, CA
Re: Update Non Default Data Source
The code should be:
Code:
fpmi.db.runUpdateQuery("UPDATE TBWorkOrder SET MachineID = 1 Where WorkOrderNumber = '1234567'", "TransOPT")
_________________ Travis Cox
Inductive Automation
Technical Support Rep.
Users browsing this forum: No registered users and 0 guests
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum
