dbQueryIsForwardOnly#

Purpose#

Reports whether you can only scroll forward through a result set.

Format#

ret = dbQueryIsForwardOnly(qid)#

Parameters:: qid (scalar) – query number.
Returns:: ret (scalar) – 1 if the result set can only be scrolled through forward, otherwise a 0.

Remarks#

Setting a query to “forward only” will usually improve performance. By default, queries are created with “forward only” on.

Examples#

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

// Check if the result set is forward-only
if dbQueryIsForwardOnly(qid);
    print "Forward-only mode is enabled";
else;
    print "Bidirectional scrolling is allowed";
endif;

See also

Functions dbQuerySetForwardOnly(), dbQuerySeekNext()