brixxbox Wiki
Search
⌃K

sqlRead

Executes a write sql statement and returns the number of rows affected

Parameters

  1. 1.
    statementName - The name of the statement
  2. 2.
    additionalParameters - all controls in the current config are set as paramters automatically. If you need to add additional parameters, you can use this json object to set them
  3. 3.
    queryOptions - (optional) a json object with options for the request
    • timeout - (optional) timeout for the SQL request. Default is 30 seconds
    • connectionKey - (optional) a key to a custom settings entry with the connection string to an external MSSQL database

Example Usages

Read all data without parameters
let rowsChanged = await brixxServerApi.sqlRead("getAddresses", {}, {timeout: 90});
Read all data with parameters
let rowsChanged = await brixxServerApi.sqlRead("getAddresses", { adrType: 1});
See also client side api sqlRead
Last modified 3mo ago