Re: [sqlite] Views

2007-07-07 Thread Mario Figueiredo
On 7/6/07, Joe Wilson <[EMAIL PROTECTED]> wrote: --- Mike Johnston <[EMAIL PROTECTED]> wrote: > I have to join three tables to retrieve bits of data from each. I'm wondering if I use a view > are there any performance issues vs. issuing the complete 3 table join query in code. As long as your

Re: [sqlite] Re: sqlite_finalize() releases resources?

2007-07-04 Thread Mario Figueiredo
On 7/4/07, Dan Kennedy <[EMAIL PROTECTED]> wrote: On Wed, 2007-07-04 at 09:58 +0200, Jef Driesen wrote: > Igor Tandetnik wrote: > > Mario Figueiredo wrote: > >> I'm a tad bit confused with sqlite3_finalize() usage when the query > >> fails. As it is, I'm assumin

Re: [sqlite] Re: sqlite_finalize() releases resources?

2007-07-03 Thread Mario Figueiredo
Thanks Igor. That's all I needed to know. Mario Figueiredo On 7/3/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Mario Figueiredo <[EMAIL PROTECTED]> wrote: > I'm a tad bit confused with sqlite3_finalize() usage when the query > fails. As it is, I'm assuming it releases r

[sqlite] sqlite_finalize() releases resources?

2007-07-03 Thread Mario Figueiredo
I'm a tad bit confused with sqlite3_finalize() usage when the query fails. As it is, I'm assuming it releases resources and I use it in this context: rc = sqlite3_prepare_v2(/* ... */); if (rc != SQLITE_OK) { sqlite3_finalize(stmt); /* ... */ } /* ... */

[sqlite] Generating documentation (mingw, activestate tcl)

2007-07-02 Thread Mario Figueiredo
?p=BuildOnWindowsWithTcl and just do make doc. But it complains I don't have TeaPot. I'm stumped. And I would like to know how can I make this work on my setup. TIA, Mario Figueiredo

Re: [sqlite] Re: (New SQLite user) - ANSI Datatypes

2006-11-14 Thread Mario Figueiredo
the confusion. Thanks again. Mario Figueiredo On 11/14/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Mario Figueiredo <[EMAIL PROTECTED]> wrote: > Are ANSI datatypes recognized? I'm particularly interested in CHAR(X) > and VARCHAR(X). And they seem to work in a way I can't und

[sqlite] (New SQLite user) - ANSI Datatypes

2006-11-14 Thread Mario Figueiredo
, it does show both fields truncated to 5 characters. So I'm a little confused. What is indeed happening? Is the constraint being applied only when reading data? And then only when some command is appended to the select statement? Thank you, Mario Figueiredo