Is the SQLite HTML documentation (all the pages found under
www.sqlite.org/docs.html) available for download?? The site was down a bit
today and that can be frustrating!
-Dave
Hello Dr. Hipp,
On 19/05/2005, at 16:08, D. Richard Hipp wrote:
On Thu, 2005-05-19 at 15:58 -0400, Tito Ciuro wrote:
Hello everyone,
I just downloaded SQLite 3.2.1 to replace 3.1.2. My wrapper stopped
working iimediately. After checking why, I realized that
'full_column_names' is not working.
On Thu, 2005-05-19 at 15:58 -0400, Tito Ciuro wrote:
> Hello everyone,
>
> I just downloaded SQLite 3.2.1 to replace 3.1.2. My wrapper stopped
> working iimediately. After checking why, I realized that
> 'full_column_names' is not working. Looking through the archives
> reveals other
Hello everyone,
I just downloaded SQLite 3.2.1 to replace 3.1.2. My wrapper stopped
working iimediately. After checking why, I realized that
'full_column_names' is not working. Looking through the archives
reveals other developers having the same issue.
Is it just me or is
> I've used the windows command line SQLite utility
> without problems, but the linux version GZ file
> doesn't worked in mine tests. I extracted the file
> with gunzip, but the binary file doesn't worked. It
> can be a very basic problem to an esxperient linux
> user, but i couldn't execute the
At 19:53 19/05/2005, you wrote:
Hi!
I've used the windows command line SQLite utility
without problems, but the linux version GZ file
doesn't worked in mine tests. I extracted the file
with gunzip, but the binary file doesn't worked. It
can be a very basic problem to an esxperient linux
user, but
Claudio Bezerra Leopoldino <[EMAIL PROTECTED]> writes:
> May someone tell me a clue to execute the SQLite
> utility in linux environment? Or a need to compile the
> source code to use the utility?
> ==
> [EMAIL PROTECTED] SQLite]$ ls -l
> total 372
>
pwd is not in your path.
try ./sqlite3-3.2.1.bin
also make sure it's got the right permissions:
chmod a+x sqlite3-3.2.1.bin
HTH,
B
Claudio Bezerra Leopoldino wrote:
Hi!
I've used the windows command line SQLite utility
without problems, but the linux version GZ file
doesn't worked in mine tests. I
> Sorry, didn't mean to imply it wouldn't. You added this caveat though:
>
> > Note however that this really only does what you want when
> tableB is initially empty
Yeah, that's fairly easy to work around though. Assuming you know
the structure of the ultimate destination table, which
>
>Out of curiosity, why doesn't the idea I proposed work? If there's a
> situation where it doesn't work I'd like to know, so I don't try using
> it myself should a similar situation arise. :)
Sorry, didn't mean to imply it wouldn't. You added this caveat though:
> Note however that this
Out of curiosity, why doesn't the idea I proposed work? If there's a
situation where it doesn't work I'd like to know, so I don't try using
it myself should a similar situation arise. :)
-Tom
> -Original Message-
> From: Brown, Dave [mailto:[EMAIL PROTECTED]
> Sent: Thursday,
> So I guess I have to write my own function, "current_row()", using the
> sqlite3_create_function() APIs?
If you've got a program handling this why don't you just count them as you
retrieve them?
So I guess I have to write my own function, "current_row()", using the
sqlite3_create_function() APIs?
-Dave
-Original Message-
From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 19, 2005 8:40 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How to get row numbers in
>
>Are you sure this is true? The rowid in the source table has no
> relationship to the order of the results of the query.
You're right. I thought it was the row number of the result set, it's not:
D:\temp\convention>sqlite3 test.db
SQLite version 3.0.8
Enter ".help" for instructions
> Is there any way to SELECT out the row number of returned results in a
> query?
> For example:
>
> SELECT row_number(), value from some_table;
> 1 ValueA
> 2 ValueB
> 3 ValueC
> ... etc ... ??
>
> What I really want this for is a query where I am inserting from table A
> into table B, and
If you create your Ordering column in table B as type INTEGER PRIMARY
KEY, you can do:
INSERT INTO tableB (value)
SELECT value
FROM tableA
ORDER BY ...
And when you're done, the value of tableB.Ordering will represent the
order in which the rows were inserted into the
./configure --disable-shared --enable-static, enable-static is probably not
needed if you disable shared, but it doesn't hurt.
On 19 May 2005 08:30:53 -, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
>
>
> I'm an embedded user.
> Can i compile sqlite as a static binary
> (with no shared
> > Myself, I'm not a big fan of high-level abstraction from the sql
> > being performed, so I wouldn't use the originally posted idea of
> > editing a recordset.
>
> I don't tend to use it either. But some people like to do things that
> way and I'd like to make it as easy as possible for
Brown, Dave wrote:
Is there any way to SELECT out the row number of returned results in a
[...]
I want this to result in the following being added to tableB:
Value | Ordering
5 1
8 2
9 3
etc
Any ideas?
-Dave
I think you should register a new functions
19 matches
Mail list logo
