Search…
Resources
Related Links
sendCommand
To send a SQL command to a connected SQL database
In case you want to send a command to a connected SQL database, use this function to send your command as a string through a specified connection.
Mehr Informationen zu SQL-Verbindungen.
Only available on Ninox Private Cloud and On-Premises. Please get in touch with our Sales team.

sendCommand(string, string)

JSON

sendCommand(connectionName, command) To send a given SQL command to a connected SQL database by specifying the connection name.
1
do as server
2
formatJSON(sendCommand("MySQLConnection", "SELECT 1"))
3
end
Result:
{result: {"recordsets":[[{"id":2,"name":"feature a","price":99.99,"created_at":"2021-06-02T08:00:00.000Z"}]],"recordset":[{"id":2,"name":"feature a","price":99.99,"created_at":"2021-06-02T08:00:00.000Z"}],"output":{},"rowsAffected":[1]}}

​queryConnection, which sends a SQL command to a connected SQL database and returns the record data.
Last modified 1mo ago
Export as PDF
Copy link
On this page
Syntax
Return
Examples
See also