||Re: SQL where with date variable
Akshat Kapoor <email@example.com>
||Sun, 24 Nov 2019 18:24:44 +0530
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
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
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