system.db.runSFUpdateQuery
Deprecated by new system.db functions in 8.3
It is recommended to use the system.db.execUpdateAsync and system.db.runSFPrepUpdate variants instead.
Click here to learn more about new system.db functions.This function is used in Python Scripting.
Description
Runs a query through the Store and Forward system and to multiple datasources at the same time.
Client Permission Restrictions
Permission Type: Legacy Database Access
Client access to this scripting function is blocked to users that do not meet the role/zone requirements for the above permission type. This function is unaffected when run in the Gateway scope.
Syntax
system.db.runSFUpdateQuery(query, datasources)
Parameters
| Type | Parameter | Description |
|---|---|---|
| String | query | A query (typically an UPDATE, INSERT, or DELETE) to run. |
| String[] | datasources | List of datasources to run the query through. |
Returns
Boolean - Returns true if successful and false if not.
Scope
Gateway, Vision Client, Perspective Session
Code Examples
Code Snippet
# Example 1: Run through single datasource
print system.db.runSFUpdateQuery("INSERT INTO recipes (name, sp1, sp2, sp3) VALUES ('A Name', 1032, 234, 1)", ["MySQLDatasource"])
Code Snippet
# Example 2: Run through two datasources
print system.db.runSFUpdateQuery("INSERT INTO recipes (name, sp1, sp2, sp3) VALUES ('A Name', 1032, 234, 1)", ["MySQLDatasource", "SQLServerDatasource"])