Re: Scanning through the tables in a database

2015-03-01 Thread Michael Glassman
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

Re: [NF] Pros/cons of using a standup desk, recommendations on standup/adjustable height desks

2015-03-01 Thread Man-wai Chang
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 for February 2015

2015-03-01 Thread List Administrator Account
== ProFox List Statistics February 2015 == Subscriber Count at End of Month: ProFox: 276 ProFoxTech: 180 == Total Posts:

Re: Scanning through the tables in a database

2015-03-01 Thread Jean MAURICE
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

Scanning through the tables in a database

2015-03-01 Thread Joe Yoder
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