Subject Re: SQL where with date variable From Mervyn Bick <mervyn@invalid.invalid> Date Sun, 24 Nov 2019 14:38:19 +0200 Newsgroups dbase.getting-started 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. Mervyn.