unfortunately it only supports sqlite 2 :-(
I wondered if the source for the database interface of
http://OpenOffice.org might help, since they appear to implement exactly
that -- even including an sqlite driver.
--
cheers,
Stef Mientki
http://pic.flappie.nl
thanks Donald,
I should be ashamed, as OpenOffice is my standard office package,
didn't know OpenOffice supported SQLite (MS-Access didn't ),
so I'll take a look.
--
cheers,
Stef Mientki
http://pic.flappie.nl
-
To
Stef,
Regarding:
"(I'm interested in this differences, because I'm trying to generate
SQL statements from a visual design, like in MS-Access.
If anyone knows good literature about generating SQL statements from
graphical designs, I'ld be much obliged.)"
===
I wondered if the source for the
Q1:
What's the difference between ON and WHERE,
the 2 statements below return exactly the same ?
SELECT Patient_text.*, Opnamen.*
FROM Patient as P
INNER JOIN Patient_text, Opnamen
ON P.PatNr = Patient_text.PatNr
WHERE P.PatNr = '1'
SELECT
4 matches
Mail list logo