Stephen, you might want to look at
http://dabodev.com/ Among other DBs it does support Sqlite and is fully cross-platform Cheers, Kai On Thu, 15 Aug 2013 17:39 +0100 (BST), Stephen Hughes wrote: > Sorry if the following is a duplicate but I've just updated to the latest > version of my email > client and it seems to be leaving messages in the out-basket! > > Thank you Simon for your very comprehensive and interesting reply, especially > the SQL examples > >> - set MAXIMUM/MINIMUM values. >> > CREATE TABLE journeys ( > start TEXT, > destination TEXT, > distance REAL, > CHECK (distance BETWEEN 0.0 AND 5000.0), > CHECK (start != destination)) > >> - allow me to force UPPER case. >> > CREATE TABLE airports ( > designation TEXT, > fullName TEXT, > city TEXT, > country TEXT, > CHECK (designation == UPPER(designation)), > CHECK (fullName NOT NULL), > CHECK (designation != '')) > > both of which will be extremely useful. But as I said in my last post I got > confused between > Visual FoxPto SQL and Visual FoxPro built in programming language. I could > certainly achieve what > I want by using a spreadsheet, such as LibreOffice Calc, to create a > validated and extended > temporary file which I could then use to import the relevant validated fields > to my "Order items" > table in my SQLite database; but this seems to be a rather long-winded and > circuitous approach. > _______________________________________________ sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
