SqlRequest

SqlRequest

Request function

[[S r1] r1] SqlRequest (

SqlDB _db_

S _request_

[SqlParam r1] _params_

)

Parameters

_db_

any SqlDB

_request_

the SQL request is given in text form
the request parameters appear as '?' characters
the list of parameters (third argument in the SqlRequest function) uses the same order and number of '?' characters as in the SQL request
the nil value of Scol corresponds to NULL SQL

_params_

parameters, see SqlParam type

Return value

the result is a list of character string lists representing the list of responses to the request, where each response is a list of columns

_db_
	any SqlDB
_request_
	the SQL request is given in text form the request parameters appear as '?' characters the list of parameters (third argument in the SqlRequest function) uses the same order and number of '?' characters as in the SQL request the nil value of Scol corresponds to NULL SQL
_params_
	parameters, see SqlParam type