Page 1 of 1

revNumberOfRecords and odbc

Posted: Mon Dec 23, 2013 12:15 pm
by 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

Re: revNumberOfRecords and odbc

Posted: Mon Dec 23, 2013 1:43 pm
by 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