Skip to main content

sqlWrite

Parameters​

  1. statementName - The name of the statement
  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. 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​

Update a record with parameters

   let rowsChanged = await brixxServerApi.sqlWrite("updateAddres", {
       newName: "John",
       addressId: 45,
   });

See also client side api ../../client-api-reference/functions/sqlwrite.md