Difference between revisions of "SQLCNT"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (2 intermediate revisions by one user not shown) | |||
| 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 | ||
| Line 19: | Line 12: | ||
==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. | |
| − | + | ||
| − | + | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | + | OPEN DATABASE southwind | |
| − | + | SELECT * FROM example WHERE state = "MA" | |
| − | + | ? sqlcnt | |
| − | SELECT | + | 17 |
| − | FROM | + | |
| − | WHERE | + | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
</code> | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Pseudo Columns]] | [[Category:Pseudo Columns]] | ||
Latest revision as of 14:51, 5 July 2011
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
