Call Us 1-800-266-7798   |   Schedule a Demo

International Distributors

Back
Showing 2191 - 2200 of 4306 results
  • system.db.runSFPrepUpdate | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-runSFPrepUpdate
    Runs a prepared statement query through the store and forward system and to multiple datasources at the same time.
  • system.db.runQuery | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-runQuery
    Runs a SQL query, usually a SELECT query, against a database, returning the results as a dataset.
  • system.db.runNamedQuery | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-runNamedQuery
    Runs a named query and returns the results.
  • system.db.refresh | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-refresh
    This function will programmatically cause a SQL Query or DB Browse property binding to execute immediately.
  • system.db.getConnections | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-getConnections
    Returns a dataset of information about each configured database connection. Each row represents a single connection.
  • system.db.getConnectionInfo | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-getConnectionInfo
    Returns a dataset of information about a single database connection, as specified by the name argument.
  • system.db.execSProcCall | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-execSProcCall
    Executes a stored procedure call.
  • system.db.rollbackTransaction | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-rollbackTransaction
    Performs a rollback on the given connection.
  • system.db.runScalarPrepQuery | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-runScalarPrepQuery
    Runs a prepared statement against a database connection just like the runPrepQuery function, but only returns the value from the first row and column.
  • system.db.runScalarQuery | Ignition User Manual
    https://docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-db/system-db-runScalarQuery
    Runs a query against a database connection just like the runQuery function, but only returns the value from the first row and column.