Subject Re: SQL where with date variable
From Akshat Kapoor <>
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

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