Contents

Previous

Next

OMSQL-> introduction sqlconnect sqlexec sqlfetch sqlcolnames sqlnumrows sqltables sqldisconnect

sqlnumrows

Index-> contents reference index search

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