revNumberOfRecords and odbc

[D4vidrim]

Hi,
as I read on the Dictionary, revNumberOfRecords function does not work on ODBC data sources.
Is there any alternative?

What I would like is the number of record, in order to use a progress bar to show how many records are being processed so far.

Thanks

[Klaus]

Hi David,

does ODBC support SQL? If yes, you can use a SQL command:
...
The COUNT(*) function returns the number of records in a table:
SELECT COUNT(*) FROM table_name
## = number of records
...

Best

Klaus