Xojo Docs - Getting Started: Working with Databases
How do I get the number of rows in a RecordSet?
[quote]Alternatively, you can create a SQL SELECT statement to return the number of rows in a query. This is done using the COUNT method. The exact syntax varies by database, but is usually something like this:
[/quote]SELECT COUNT(*) As RowCount FROM TableName WHERE value1 = x AND value2 = y