Doug Could it be that the select sum picks up all columns in the table and list command does not include the system table columns
Buddy -----Original Message----- From: [email protected] <[email protected]> On Behalf Of Doug Hamilton Sent: Tuesday, January 24, 2023 11:34 PM To: R:Base List <[email protected]> Subject: [RBASE-L] - Number of Columns in a DB Curious discrepancy: When I SELECT SUM(SYS_NUM_COLUMNS) INTO vSumCols FROM SYS_Tables from a database, the sum is 1395. When I do a List command, the number of columns in the database is 1346. In another database, the sum was 698, List command was 614. The databases were just connected so there were no temp tables or views. The columns in permanent views don't account for the difference. Not a pressing issue, just a curiosity. Any ideas? I'm sure the answer is simple - that's why it's escaping me. Doug -- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/28ec98ff-f00c-3127-0dc8-be64e9594c67%40wi.rr.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/001801d930c7%247d77ab00%2478670100%24%40comcast.net.
