Why not copy the records with ObjectType = “Table” into a free table, close the
.dbc table, then do a record count on each file listed in the free table?
Mike
From: Joe Yoder
Sent: Sunday, March 01, 2015 1:53
Beware of problems caused by prolonged standing, as for example,
varicose veins and spider veins!
On Sat, Feb 28, 2015 at 8:57 PM, Brian Pow brian@lineone.net wrote:
Many years ago I was a junior in a small accountancy practice. The elderly
senior clerk there worked at a high desk with a
==
ProFox List Statistics
February 2015
==
Subscriber Count at End of Month:
ProFox: 276
ProFoxTech: 180
==
Total Posts:
Hi Joe,
you can use ADBOBJECT() to get all the tables of a database in an array as in
the example given in the help :
* Open sample testdata database
OPEN DATABASE (HOME(2) + 'Data\testdata')
* Function call with cSetting for table names
=ADBOBJECTS(gaTables, TABLE)
* Displays array gaTables
I want to get the number of records in each of the tables in a database.
When I open the .dbc file as a table I can scan for ObjectType = 'Table'
and get the names but when I try to do a select cnt(*) from (objectname)
into array Cnt I get the message that The database for table ... could
not be
5 matches
Mail list logo