Contents Previous Next sqlnumrows

Obtaining the Number of Rows in a Result Set
Syntax sqlnumrows
See Also sqlcolnames , sqlexec

Description
Returns an integer scalar that equals the number of rows in the most recently generated result set.

Examples
If, at the O-Matrix prompt you enter
     sqlconnect("driver={Microsoft Access Driver (*.mdb)};Dbq=c:\omwin\omsql\Contacts.mdb;UID=;PWD=")
     sqlexec("SELECT CompanyID, CompanyName FROM Company WHERE Country = 'USA' ORDER BY City")
     print sqlnumrows
O-Matrix will respond
4