Count(*) returns zero incorrectly ?!?
Posted: Wed Feb 07, 2007 9:56 am
When I issue the command SELECT * FROM MYTABLE I get a endlessly scrolling list of rows (as I should, since there are ~ 10 million rows in the table.) But when I issue the command SELECT COUNT(*) FROM MYTABLE I get zero!
Any ideas as to what may be wrong? BTW, we just copied over the *.TBL from one machine to this one. How to we get the system tables in synch?
Any ideas as to what may be wrong? BTW, we just copied over the *.TBL from one machine to this one. How to we get the system tables in synch?