Project

General

Profile

Previous Up Next

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