Thought I'd sent this yesterday but found it stuck in my Outbasket
today:-(
Thanks David & Kai - off to look at Kexi and Dabo. Will let you know how
I get on.
I have now downloaded both Kexi & Dabo.
Kexi - despite stating that a Windows version is available, when I try to
download all I get is th
Am 16.08.2013 17:47, schrieb Kai Peters:
Stephen,
you might want to look at
http://dabodev.com/
Among other DBs it does support Sqlite and is fully cross-platform
Cheers,
Kai
Hello Stephen,
maybe another alternative is, to run FoxPro on a linux machine with the
windows emulator wine.
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 emai
Thank you David for correctly pointing out:-
> Perhaps the better question for you to be asking is what software
> would best meet your needs in creating a form that will interface
> with sqlite's db back end.
That is precisely the question I should have asked (should I start a new
thread?).
OO
I've never used Visual FoxPro, but I suspect that it allows you to create forms
to insert data in to the database.
Sqlite doesn't do that. Sqlite only provides the library to store the data via
SQL statements that you execute via sqlite3_prepare()/sqlite3_step() function
calls.
You are expec
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
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 != des
On 13 Aug 2013, at 8:56am, Stephen Hughes wrote:
> Thanks Stephen, Simon & Kees for your replies all of which indicate that
> I am starting from the wrong place, in that it is the built-in
> programming capabilities of Visual FoxPro that I was using rather than
> its Database Engine.
> Without w
Thanks Stephen, Simon & Kees for your replies all of which indicate that
I am starting from the wrong place, in that it is the built-in
programming capabilities of Visual FoxPro that I was using rather than
its Database Engine.
Without wishing to digress into which is the best programming language
On Mon, 12 Aug 2013 10:51 +0100 (BST), "Stephen Hughes"
wrote:
>SQLite Input with validation and lookup
>This may be a FAQ, if so please point me in the right direction, but if
>not what I am looking for is a BROWSE style INPUT which will:-
> - allow me to force UPPER case.
> - set MAXIMUM/MINIMU
On 12 Aug 2013, at 10:51am, Stephen Hughes wrote:
> SQLite Input with validation and lookup
> This may be a FAQ, if so please point me in the right direction, but if
> not what I am looking for is a BROWSE style INPUT which will:-
> - allow me to force UPPER case.
> - set MAXIMUM/MINIMUM values.
You're not exactly clear on where these restrictions come from, but,
database wise, SQLite has no care or real control over what data it will
retain, only the control that it will retain and attempt to protect your
data. The application level is what determines what goes into the
database.
- To l
SQLite Input with validation and lookup
This may be a FAQ, if so please point me in the right direction, but if
not what I am looking for is a BROWSE style INPUT which will:-
- allow me to force UPPER case.
- set MAXIMUM/MINIMUM values.
- LOOKUP and retrieve data from a masterfile.
For example:
13 matches
Mail list logo