Program.SqlCursor Class

Inheritance Hierarchy

ASNA.Monarch
    ASNA.Monarch.Program
        ASNA.Monarch.Program.SqlCursor

Syntax

BegClass Program.SqlCursor Access(public) Inherits (ASNA.Monarch.Program)

Thread Safety

Any public static (Shared) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Remarks

When the query is done using a cursor, the set of rows returned consists of all the rows that satisfy the conditions in the WHERE clause of the statement. As long as the cursor remains open, the logic can scroll via Fetch to get data-rows from the result set.

This is in contrast to the single-row ExecuteSQL_Query, which results in only one data row that matches the search criteria.

Requirements

See Also

ASNA.Monarch Namespace

Program.SqlCursor Class Members

Program Class

Program.SqlQueryResults Field

Program.DBParm Class

Embedded SQL Overview