Subject Re: SQL where with date variable From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Sun, 24 Nov 2019 18:24:44 +0530 Newsgroups dbase.getting-started On 24/11/2019 15:03, Robbie Nott wrote: > > Thanks Mervyn > > Thanks for that, had no idea that there was "dBase SQL" and "proper SQL" dbase sql or local sql is sufficient for most of the work. It has some shortcomings but when you reach that level you will probably be using some proper backend RDBMS > > For a program that might run on either maybe I should just stick to > my tried and trusty "Select * from StockTran" and do the filtering > in my Do While loops... I would suggest not. Filtering with WHERE in Sql is much faster than filtering while looping through. Use of params is the best and easiest. If you require just the current date everyday then I would suggest have a look at data modules also. Once designed the sql expression can even be modified to have variables in sql Without the use of WHERE in sql my app would be running at a snails pace. I regularly select just 1 or 2 rows from approx 12000 in a flash. It is much much faster than canGetrow/ filter etc Regards Akshat