dbQueryIsSelect

Purpose

Reports whether the specified query is a SELECT statement.

Format

ret = dbQueryIsSelect(qid)
Parameters:qid (scalar) – query number.
Returns:ret (scalar) – 1 if the query is a SELECT statement or 0 otherwise.

Examples

// Execute query
qid = dbExecQuery(db_id, "SELECT *
    FROM PEOPLE");

// Check whether `qid` query is a `SELECT` statement
dbQueryIsSelect(qid); // True

// Execute new query
qid = dbExecQuery(db_id, "INSERT INTO
    PEOPLE (fname, lname) VALUES
    ('John', 'Doe');");

// Re-check whether `qid` query is a `SELECT` statement
dbQueryIsSelect(qid); // False