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.