dbCreateQuery¶
Purpose¶
Process an SQL statement and prepare a query. If placeholders is present, these values are bound sequentially to ODBC style parameters.
Format¶
-
qid =
dbCreateQuery
(db_id[, query[, placeholders]])¶ - Parameters
db_id (scalar) – database connection index number.
query (string) – optional. database query to construct.
placeholders (string or string array) – optional. containing bind value(s).
- Returns
qid (scalar) – query id to be used for result retrieval.
Examples¶
Example 1¶
// Create and prepare query
qid = dbCreateQuery("SELECT * FROM GDP
WHERE COUNTRY = ?", "USA");
dbQueryExecPrepared(qid);
// Results as a matrix
results = dbQueryFetchAllM(qid);
Example 2¶
// Create query
qid = dbCreateQuery("INSERT INTO
PEOPLE(id, fname, lname) VALUES
(NULL, ?, ?);");
// Set the placeholder
dbQueryBindValue(qid, "Joe");
// Set the placeholder
dbQueryBindValue(qid, "Smith");
// Execute query
dbQueryExecPrepared(qid);
Remarks¶
If the placeholders parameter is passed in, the values are bound sequentially to ODBC style parameters.
See also