[sqlite] Recursive Query

Hi All, I just want to know if WITH RECURSIVE query is supported by SQLite. Thanks in advance. Regards, Alex ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] About sqlite3_bind

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 yoky wrote: > I create a table with 200 columns, If you have that many columns but want queries with only some of them, then it is a good indication that your schema is not normalized. See the wikipedia entry for some guidance:

Re: [sqlite] About sqlite3_bind

"yoky" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I try to select like this: >sqlite3_prepare(db, "select ?,?,? from tbl1 where ID=1", -1, > , 0); >sqlite3_bind_text(stat, 1, "ID", -1, 0); >sqlite3_bind_text(stat, 2, "age", -1, 0); >

[sqlite] About sqlite3_bind

Hi all, I create a table like this: "create table tbl1(ID integer primary key, age integer, name text)" insert a record: "insert into tbl1 values(1,25,'aaa')" I try to select like this: sqlite3_prepare(db, "select ?,?,? from tbl1 where ID=1", -1, , 0);

Re: [sqlite] Distinguishing between sqlite3_stmts

Roger Binns wrote: >> John Stanton has correctly pointed out that there is a programming model >> here an application effectively does the cacheing itself by precompiling > > statements at startup. > > That is not caching and it would be unaffected by any caching scheme. > sqlite3_finalize

[sqlite] How To Compile SQLite into jar for MacOSX

Hi list, I wanted to test SQLite to use it with WebObjects and almost make it. I can connect and I can query, but I can't insert. Actually what I found out was that all SQL statements go through executeQuery method which expects a Result Set otherwise will throw a SQLException. I think I can

[sqlite] (no subject)

What is the proper syntax to set a variable to the error code using errorcode method and TCL. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] (no subject)

What is the proper syntax to set a variable to the error code using errorcode method and TCL. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Distinguishing between sqlite3_stmts

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Douglas E. Fajardo wrote: > John Stanton has correctly pointed out that there is a programming model here > an application > effectively does the cacheing itself by precompiling statements at startup. > In this situation, > the proposed cacheing

[sqlite] (no subject)

What is the proper syntax to set a variable to the error code using errorcode method and TCL. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Distinguishing between sqlite3_stmts

Roger and John both, of course have good points - John Stanton has correctly pointed out that there is a programming model where an application effectively does the cacheing itself by precompiling statements at startup. In this situation, the proposed cacheing feature represents double

Re: [sqlite] Distinguishing between sqlite3_stmts

Rodger: Thanks for creating the ticket. I will be interested to see the result when (if? :-) it gets implemented. Dan: It was my thought that a single, well thought-out implementation of caching (as opposed to something that each programmer implements on an 'ad-hoc' basis) would offer a

[sqlite] Incorrect results from SELECT DISTINCT

Hello, In SQLite 3.5.9, this misbehavior occurs: [EMAIL PROTECTED]:~$ sqlite3 SQLite version 3.5.9 Enter ".help" for instructions sqlite> CREATE TABLE foo(foo TEXT); sqlite> INSERT INTO foo VALUES ('a'); sqlite> INSERT INTO foo VALUES ('b'); sqlite> SELECT DISTINCT

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

Jay, I thank you for an inciteful and well considered position piece, and I respond in-line below ... (sorry for the length, but I found it difficult to excise much of the excellent description that you wrote). On Mon, 10 Nov 2008, Jay A. Kreibich wrote: [regretfully elided owing to space

Re: [sqlite] HELP: prep'ed query ... LF function to return column_isNull??

On Sat, Nov 08, 2008 at 09:48:10PM -0500, Rob Sciuk scratched on the wall: > Thanks, Igor, but I'm not looking for the type (either declared or > affined), but rather whether the actual value is valid, or NULL. That was > the point of the original post. My problems arose from the fact that it

Re: [sqlite] Distinguishing between sqlite3_stmts

You make a argument for Bloatware. It is not oersuasive. JS Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > John Stanton wrote: > >>Perhaps this featrure could be reserved for "Sqlheavy", a replacement >>for Oracle. > > > Or a #if OMIT_STATEMENT_CACHE like all sorts

Re: [sqlite] Program crashes on delete row in SQLite db table

Attachments don't work on this mailing list, so please post the image online somewhere and send a link. -- Joshua Paine LetterBlock: Web applications built with joy http://letterblock.com/ 301-576-1920 ___ sqlite-users mailing list

[sqlite] Program crashes on delete row in SQLite db table

Hello, I build an application in VC++ platform and using SQLite to keep track details that used to update when the application runs. Sometimes the application is crashing when execte query to delete a row in a table (DELETE FROM table where column = 'field1'). the API uses is "sqlite3_exec()".