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 PM To: [email protected] Subject: Scanning through the tables in a database 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 opened. Would you like to try to locate the owning database or delete the link (and free the table)? Apparently if the DBC is open as a table it cannot be opened as a database and the system will not let a file linked to a database be opened if the database cannot be opened as well. There are a number of workarounds that I can think of but I'm wondering - Is there is a way to scan through the files in a database while the DBC is open as a database? Thanks in advance, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/A35C27CF806B49829F168BCB93E36EE9@Studio17 ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
