Reading the documentation I found that .RowCount is not supported for MySQL. Is there a way to get the number of records without actually having to count them one by one with a FOR... NEXT loop?
I'm regretting not choosing PostgreSQL :(
@HectorMarroquin Reading the documentation I found
Xojo Docs - Getting Started: Working with Databases
How do I get the number of rows in a RecordSet?
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:
SELECT COUNT(*) As RowCount FROM TableName WHERE value1 = x AND value2 = y
and oracle knows this
just wait until they come to you asking for money
that said rewriting a query to get the count at the same time you get the actual results is one option
its not always possible since it may affect other aggregates with group by etc
so sometime running the query twice is the only opton
or just NOT writing your code / UI to show something that can be a pain or expensive to get
In this case I do need to get the data so no chance of not having to deal with the pain of the latency. I'm working on a Web App so the purpose of getting the record count is to determine if the data is to be displayed on a WebListBox or create an HTML page to display the data, there are a few cases in which up to 3,000 records need to be read and not only does this take time to process but the WebListBox would most probably be turned useless with that many rows.
Thanks for the input!