Subject Re: Connection string in ADODatabase From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Tue, 27 Oct 2020 15:33:42 +0530 Newsgroups dbase.getting-started Good Afternoon Mervyn, > For a small table it probably doesn't really matter but for a large > table you certainly don't want to fetch the entire table into memory if > all you want to do is to count the records. > > Let the SQL server do the counting (which it can almost certainly do > faster than dBASE anyway) and then return one record with one field > containing the count.  This will minimise the traffic on the network. Hope all is well. This was just a test case hence opted for msgbox(rowset.count()) to check if rows are returned or not. Was expecting your response in a completely different thread in the sql-servers newsgroup SQL error with Group By on WAMP but not on XAMPP. Gaetano has solved it on his own. I have provided him with the logic. But was hoping for a better worded explanation. It would have shown that your morning coffee was a strong one. Regards Akshat