||Re: SQL where with date variable
Mervyn Bick <email@example.com>
||Sun, 24 Nov 2019 14:38:19 +0200
On 2019/11/24 11:33, Robbie Nott wrote:
> Thanks Mervyn
> Thanks for that, had no idea that there was "dBase SQL" and "proper SQL"
> 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...
That "proper" was a bit tongue in cheek hence the quote marks.
dBASE has localSQL built in (as part of the BDE) and this is a fairly
limited subset of standard SQL. There is a help file but it's fairly
well hidden and it can't be used in Windows 10 unless Windows 10 is
patched. All is, however, not lost. In the binaries newsgroup Bruce
Beacham posted a .pdf version on 2018-12-08 and Graham Monk posted a
.chm version on 2019-01-06 in the thread "LocalSQL Help".
Despite only being a subset of SQL localSQL can be very useful.
Although there is a SQL standard most of the "proper" SQL servers out
there such as MySQL, MariaDB, SQL Server, Oracle, Firebird, to name but
a few, deviate from the standard in many respects.
Apart from the fact that one should adopt a different programming
technique when data is to be stored on a SQL server it is very
difficult (if not impossible) to create a program that can be used "out
of the box" with any SQL server.