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