Re: [sqlite] Confusing FAQ(26) wording

> > http://www.sqlite.org/nulls.html > > seems to clarify things for me on this topic. > That definitely helps. Perhaps someone could add this link in the FAQ(26)? Thanks Pavel and Adam. Tobias ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Bug

> Already fixed.  Seehttp://www.sqlite.org/src/info/f74beaabde I'm might be wrong because I didn't check with the newest binary, but if I remember correctly this fix will compare t3.a to t1.a (instead of t2.a). So it will produce different results (first select will be 1|2 and second will be

Re: [sqlite] BUG Report -- schema.test does not check for authorization in build

Thanks for the reports on the TCL test cases. I think http://www.sqlite.org/src/vinfo/97f8a886b6 should correct everything you reported. On Tue, Dec 29, 2009 at 1:02 PM, Noah Hart wrote: > Test schema-13.1 fails with > Error: {authorization not available in this build} > >

Re: [sqlite] selective result columns

> -Ursprungligt meddelande- > Från: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] För nomorecaddy > Skickat: den 31 december 2009 17:44 > Till: sqlite-users@sqlite.org > Ämne: Re: [sqlite] selective result columns > > > I'm operating at the user level in a

Re: [sqlite] Mozilla's method

Hello Olaf! Thank you for your reply. I am using your wrapperlib (and I love it) but I thought it was a more general question and had nothing directly to do with your wrapperlib. But I am not sure anymore what is yours and what is common Sqlite. Your .Sychronous = False property does everything as

Re: [sqlite] mode is not changed

On 31 Dec 2009, at 4:56pm, Kees Nuyt wrote: > On Thu, 31 Dec 2009 04:24:51 +, Simon Slavin > wrote: > >> On 31 Dec 2009, at 2:13am, Wensui Liu wrote: >> >>> i am trying to change the output by 'sqlite3 mydb ".mode csv"'. >>> however, when i type 'sqlite3 mydb .show',

Re: [sqlite] Mozilla's method

On Thu, Dec 31, 2009 at 9:06 AM, Bert Nelsen wrote: > It's here: > > https://developer.mozilla.org/en/Storage:Performance > Thanks. I've removed the outdated information. Cheers, Shawn ___ sqlite-users mailing list

Re: [sqlite] selective result columns

> I'm operating at the user level in a java application.  The application > allows me to run an SQL query, then it renders the output into HTML. OK. Some third-party java application allows you to execute SQL query and show you result as HTML. Then you take this HTML and show it to somebody else?

Re: [sqlite] Mozilla's method

"Bert Nelsen" schrieb im Newsbeitrag news:a5ffd530912310853t7024d908tefbf1ef40df47...@mail.gmail.com... > I would like to make writes to my SQLite db faster. In what regard (under which circumstances) is it slow currently? What's your typical recordcount per

Re: [sqlite] [sqlite-dev] Sqlite Query Escaping

On Thu, 31 Dec 2009 10:19:24 -0500, Tim wrote: > I have the need to prepare some strings for including > into sqlite, I have not found an escape function, but I > was wondering if anyone had any comments about the > following code snippet. I had read on the site > sqlite.org web site that '

Re: [sqlite] Mozilla's method

It's here: https://developer.mozilla.org/en/Storage:Performance On Thu, Dec 31, 2009 at 6:04 PM, Shawn Wilsher wrote: > Where did you see this? It's inaccurate, and if I can, I'll remove it. If > you want to use a proper asynchronous statement execution which wraps your

Re: [sqlite] Mozilla's method

Where did you see this? It's inaccurate, and if I can, I'll remove it. If you want to use a proper asynchronous statement execution which wraps your statement[s] in a transaction, you want to use this: https://developer.mozilla.org/En/Storage#Asynchronously Cheers, Shawn Wilsher Mozilla

Re: [sqlite] mode is not changed

On Thu, 31 Dec 2009 04:24:51 +, Simon Slavin wrote: > >On 31 Dec 2009, at 2:13am, Wensui Liu wrote: > >> i am trying to change the output by 'sqlite3 mydb ".mode csv"'. >> however, when i type 'sqlite3 mydb .show', I couldn't see the change >> of mode at all. > >Each

[sqlite] Mozilla's method

Hello, I would like to make writes to my SQLite db faster. I was thinking about the Async method, but I think I remember reading somewhere that it may cause database corruption. Now I read something on the Mozilla pages, and I don't understand what exactely they are doing. Do they bundle

Re: [sqlite] selective result columns

I'm operating at the user level in a java application. The application allows me to run an SQL query, then it renders the output into HTML. I want to avoid showing empty colums in the HTML output, so I wanted the include/exclude column logic in my actual SQL statement. Pavel Ivanov-2

Re: [sqlite] Bug

On Dec 31, 2009, at 6:27 AM, Wiktor Adamski wrote: > SQLite version 3.6.21 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> create table t1(a int); > sqlite> create table t2(a int); > sqlite> create table t3(a int); > sqlite> insert into t1 values(1); >

[sqlite] Bug

SQLite version 3.6.21 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table t1(a int); sqlite> create table t2(a int); sqlite> create table t3(a int); sqlite> insert into t1 values(1); sqlite> insert into t2 values(2); sqlite> insert into t3 values(1);

Re: [sqlite] undefined reference to `readline'

Hi, you put me on the right direction and I solved. Thank you veru much !!! Hoping to help other sqlite users with the same problem, I give here a list of what I did to solve. => I checked if readline was installed and answer was not => downloaded readline.tar.gz (vers 6) and installed =>