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

Reply via email to