SQLCNT

Purpose

Return the number of rows affected by the last SQL statement

Syntax

SQLCNT

See Also

PSEUDO COLUMNS, INSERT, SELECT, UPDATE

Description

SQLCNT will return the number of rows affected by the last SQL statement. For example, after a SELECT statement, SQLCNT will contain the number of rows selected.

Example

OPEN DATABASE southwind
SELECT * FROM example WHERE state = "MA"
? sqlcnt
        17