Difference between revisions of "SQLCNT"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Return the number of rows affected by the last SQL statement | Return the number of rows affected by the last SQL statement | ||
− | |||
==Syntax== | ==Syntax== | ||
SQLCNT | SQLCNT | ||
− | |||
==See Also== | ==See Also== | ||
[[PSEUDO COLUMNS]], [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] | [[PSEUDO COLUMNS]], [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] | ||
− | |||
==Description== | ==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. | 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== | ==Example== | ||
Line 23: | Line 19: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Pseudo Columns]] | [[Category:Pseudo Columns]] |
Revision as of 13:26, 10 February 2012
Contents
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