Chad Whitacre wrote:
I am interested in the reasoning behind SQLite's dedication to the
public domain vis-a-vis other copyright/licensing options (GPL, BSD,
etc.) Is there any documentation available on this decision?
It comes down to goals. If your goal is to give other people code to
use,
Noel Frankinet wrote:
Hello,
Is there a better way to list all table making a view than parsing
SQL. Is there an API ?
You may be able to do this using the 'explain' statement
for example, I have a view called 'myview'. Wrapping this into an sql
select statement and proceeding this with
On May 26, 2005, at 12:58 PM, Hans Bieshaar wrote:
Enter ".help" for instructions
sqlite> .mode columns
sqlite> .header on
sqlite> pragma short_column_names;
short_column_names
Ok. I am an idiot. The 's' was just being truncated. Sorry for the
noise.
On May 26, 2005, at 12:58 PM, Hans Bieshaar wrote:
Enter ".help" for instructions
sqlite> .mode columns
sqlite> .header on
sqlite> pragma short_column_names;
short_column_names
Interesting. Then this may be a bug in my wrapper. Thanks for doing
the sanity check.
I don't know if I'd call this a bug, exactly, but if you do
PRAGMA short_column_names
to get the short_column_names setting, the result you get back has a
column named "short_column_name". In other words, the column name
lacks an 's' at the end.
All of the databases I've used required the columns in the order by
clause also be present in the result set. It may not be universally true though
On 5/26/05, Cronos <[EMAIL PROTECTED]> wrote:
> It seems to me that MySQL and PostgreSQL are exhibitting some dubious
> guessing behaviour as to
On Thu, 26 May 2005, Drew, Stephen wrote:
>Hello,
>
>Assuming there is no external interference, how could one cause this
>error to occur through embedded use of SQLite? And why, following a
>restart of my application, does it not happen again immediately? It
>seems most odd...
>
>Any clues
It seems to me that MySQL and PostgreSQL are exhibitting some dubious
guessing behaviour as to which column it refers to, or perhaps they are
making some requirement of the order by to contain a column that is in the
resultset ??? If name were only in test11 then what would MySQL and
PostgreSQL do
mhm, the problem is i have to store the "Query strings" somewhere, so
that i'm able to prepare them again
not nice, but OK.
thanks for your answer.
Dennis Cote wrote:
Your call to sqlite3_step() is returning an SQLITE_ERROR result. The
SQLITE_SCHEMA error code will be returned by the
You may be the person I've encountered who is able to perceive
Someone Else's Problem.
:)
-Tom
> -Original Message-
> From: Will Leshner [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 26, 2005 10:58 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] qualified names in
On May 26, 2005, at 7:49 AM, Thomas Briggs wrote:
It's been our
experience that the only truly reliable way to avoid this problem
is to
be explicit.
I agree, and that's what I've always done up until now because it
never occurred to me that the SQL engine would be able to figure it
On May 26, 2005, at 7:23 AM, Gregory Letellier wrote:
try SELECT Test2.* FROM test2 inner join test11 ON
test2.id=test11.id ORDER By Name;
Thanks. I know there are ways to get the query to work. I think the
problem is when people are migrating over from another database
engine and they
Peter Hermsdorf wrote:
hi,
i'm using a DB base class which prepares some sql statements in it's
constructor. a derived class creates additional tables in the same DB
which "invalidates" the prepared statements in the base class (because
of the schema change).
After browsing the mailinglist
try SELECT Test2.* FROM test2 inner join test11 ON test2.id=test11.id
ORDER By Name;
Will Leshner a écrit :
I guess I never really noticed this before (since I only use SQLite,
of course :) ). But consider a query like this:
SELECT test2.* FROM test2,test11 WHERE test2.id=test11.id ORDER
Hello,
Assuming there is no external interference, how could one cause this
error to occur through embedded use of SQLite? And why, following a
restart of my application, does it not happen again immediately? It
seems most odd...
Any clues would be most appreciated. This is SQLite 2.8.15.
Hi,
In the sqlite wiki below it describes the use of pragma user_version, but
doesn't really say how to use it. I'm evaluating the latest sqlite.exe.
Say on initial creation of me DB I set user_version to 1. then product with DB
schema 1 gets released.
Then at some point in the future I want
16 matches
Mail list logo