system.db.runSFUpdateQuery
Description
Runs an query through the store and forward system and to multiple datasources at the same time.
Syntax
system.db. runSFUpdateQuery( query, datasources )
-
Parameters
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
All
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 2 datasources
print
system.db.runSFUpdateQuery(
"INSERT INTO recipes (name, sp1, sp2, sp3) VALUES ('A Name', 1032, 234, 1)"
, [
"MySQLDatasource"
,
"SQLServerDatasource"
])