SQLCNT

From Recital Documentation Wiki
Revision as of 14:51, 5 July 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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


Products

Recital, Recital Server