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.