[sqlite] Duplicate keys

Hi, is the order, in which rows with duplicate keys are retrieved, specified? For example: A table with two columns - the first is a Index. If I INSERT in the following order: C1 C2 - 3 1 1 1 1 2 1 1 1 3 2 1 If I now do a SELECT * FROM Table ORDER BY C1;, is it guranteed that the rows

RE: [sqlite] java class to connect to an sqlite DB

thank you but I'm sory I'm on linux. any one have a java class to connect to an an sqlite data base. Working on linux. thaks for help --- Steve O'Hara [EMAIL PROTECTED] a écrit : Assuming you're on Windows, try this for size. Put the this DLL and the latest sqlite3.dll from the web site in

RE: [sqlite] request for additions to sqlite 3.xx

comm Wiadomosc ta jest przeznaczona jedynie dla osoby lub podmiotu, ktory jest jej adresatem i moze zawierac poufne i/lub uprzywilejowane informacje. Zakazane jest jakiekolwiek przegladanie, przesylanie,

[sqlite] SQLite Java Wrapper?

I tried to use the SQLite Java Wrapper wich I download froh here http://www.ch-werner.de/javasqlite/ I extract it I do $./configure $make but I have this errors ./libtool gcc -I -o native/mkconst native/mkconst.c \ /usr/local/lib/libsqlite3.la gcc -I -o native/mkconst native/mkconst.c

Re: [sqlite] request for additions to sqlite 3.xx

[13-05-2005 9:31, Chmielewski Andrzej escreveu] comm Wiadomosc ta jest przeznaczona jedynie dla osoby lub podmiotu, ktory jest jej adresatem i moze zawierac poufne i/lub uprzywilejowane informacje. Zakazane jest

[sqlite] Any interest on locking for 3.x in windows CE?

Hello, I finally implemented locking on the Windows CE port for the 3.x version, and did it some time ago now. The problem is I need to test it and as I don't need to use it, have been delaying the making of the tests. I was thinking if anyone that would actually use it was interested of making

RE: [sqlite] Does sqlite really support transaction?

Jay Sprenkle wrote: The transaction doesn't seem any different than a snapshot of the database that you can restore to. I just wondered why there were two methods of doing the same thing. Only in a single user/single thread case are they the same thing. With Sqlite that might always be the

RE: [sqlite] database table is locked

I think I might be getting confused on this subject as well. Does this mean that SQLite 3.x can NOT process multiple inserts/updates within one transaction if it is working on the same table? ie Below would return database table is locked? BEGIN TRANSACTION SELECT * from table1 WHERE col x

Re: [sqlite] database table is locked

On 5/13/05, Brandon, Nicholas [EMAIL PROTECTED] wrote: I think I might be getting confused on this subject as well. Does this mean that SQLite 3.x can NOT process multiple inserts/updates within one transaction if it is working on the same table? No, that seems to work fine. I guess the

RE: [sqlite] database table is locked

On Fri, 2005-05-13 at 15:16 +0100, Brandon, Nicholas wrote: I think I might be getting confused on this subject as well. Does this mean that SQLite 3.x can NOT process multiple inserts/updates within one transaction if it is working on the same table? ie Below would return database table is

RE: [sqlite] database table is locked

No, that seems to work fine. I guess the table is locked for a specific transaction, so you cannot have any problems with a lock held by the very same transaction. ie Below would return database table is locked? BEGIN TRANSACTION SELECT * from table1 WHERE col x UPDATE table1

Re: [sqlite] nested functions in select

... select count(distinct(something)) ... http://www.sqlite.org/omitted.html BTW, distinct is not a function. Regards

[sqlite] Convert and isnumeric function

All or any, Has anyone implemented these as built in functions in sqlite 3? If not - I was thinking of doing it and submitting to the sqlite.org web site for submission. Mike

Re: [sqlite] Convert and isnumeric function

All or any, Has anyone implemented these as built in functions in sqlite 3? If not - I was thinking of doing it and submitting to the sqlite.org web site for submission. The api converts data types for you. Isnumeric might be useful but since the database isn't strongly typed it

RE: [sqlite] Convert and isnumeric function

Here is the isnumeric function. Don't forget to add the line to the sqlite3RegisterBuiltinFunctions function. { isnumeric, 1, 0, SQLITE_UTF8,0, isnumericFunc}, I put it right after the abs function declartation /*

RE: [sqlite] Convert and isnumeric function

Jay, I kindly beg to differ. I have a situation where a column can contain either a name (like Joe Blow) or a numeric link to another name (like 12345). If the column contains a numeric value then the link is followed otherwise just the name is used. I would normally just handle it in

RE: [sqlite] database table is locked

It's probably not a good idea, because it depends on some behaviour that is not specified, but I once used a trick like this to get good performance: CREATE TABLE abc(a, b); UPDATE abc SET b = user2(a, b) WHERE condition AND user1(a, b); SQLite loops through the rows where condition is true, and