sqlWrite
Executes a write sql statement and returns the number of rows affected
- 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
Update a record with parameters
let rowsChanged = await brixxServerApi.sqlWrite("updateAddres", {
newName: "John",
addressId: 45,
});
Last modified 3mo ago