This API requires Profound.js version 4.15.0 or above.
Using this API can significantly improve performance. These SQL statements are all initiated at the same time, rather than one at a time.
This API can accept an optional database connection definition object to select between multiple database connections. To select the database connection, call pjs.getDB() and pass the result as the first parameter, followed by the parameters documented below. If a database connection definition object is not passed, the default database connection is used.
An array of SQL statements
- String - SQL statement
- Array - With the following elements [SQLStatement, token1, token2, etc...]
An array of objects, In the below code example, qryResults will have 3 elements.
- qryResults - the results of running sql1
- qryResults - the results of running sql2
- qryResults - the results of running sql3
Each of those individual results is based on if that SQL statement was run successfully or not. If successful, result will be an array of the data. If not successful, result will be an object containing information about that failure.
Every SQL statement will be executed, and the result array sequence will match the parameter sequence.