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?
Wed Aug 04, 2010 6:34 am
Joined: Sun Apr 02, 2006 2:46 pm Posts: 1982 Location: Sacramento, CA
Re: Update Non Default Data Source
The code should be:
fpmi.db.runUpdateQuery("UPDATE TBWorkOrder SET MachineID = 1 Where WorkOrderNumber = '1234567'", "TransOPT")
_________________ Travis Cox
Technical Support Rep.
Users browsing this forum: Google [Bot] 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