Re: [sqlite] difference between sqlite3_reset() and sqlite3_clear_bindings()

--- Patrick Dunnigan <[EMAIL PROTECTED]> wrote: > Can someone please explain the difference between sqlite3_reset() and > sqlite3_clear_bindings() > and when would I use one over the other. _clear_bindings() sets the bound values of all SQL variables in a compiled statement to NULL. I don't

Re: [sqlite] Mozilla + SQLite?

On Wed, 2005-07-06 at 08:40 -0700, Scott Baker wrote: > Looks like Firefox is gearing up to store some of its information in > SQLite? Does anyone know anything more about this? > > http://gemal.dk/blog/2005/07/06/mozilla_firefox_bookmarks_in_for_a_rewrite/ We'll be using sqlite, but not directly

[sqlite] SQLite encryption key length?

For those using the encrypted SQLite extension: The instructions say the max key length can be 256 *bytes*, and looking at the code does seem to confirm this. But there is also a comment at the top of the encryption code which says "change the maximum key size to 56 *bits* in order to comply

Re: [sqlite] conditional queries against views

On Thursday 07 July 2005 04:13 pm, Marvin Bellamy wrote: > Thanks for the join tip. This must be a 3.2.1-specific bug, because > that last example doesn't work for me. Looks like its been reported > already. Oops.. guess I missed that. this works great: sqlite> create view v2 as select a.id as

Re: [sqlite] conditional queries against views

Thanks for the join tip. This must be a 3.2.1-specific bug, because that last example doesn't work for me. Looks like its been reported already. -- Marvin Keith Bellamy Software Engineer Innovision Corporation 913.438.3200 Stephen Leaf wrote: On Thursday 07 July 2005 02:19 pm, Marvin

Re: [sqlite] conditional queries against views

On Thursday 07 July 2005 02:19 pm, Marvin Bellamy wrote: > Can anyone explain why these queries don't work? And, is there a > workaround? > > create table t1 (id int); > create table t2 (id int, name varchar(32)); > create view v1 as select a.id, b.name from t1 a, t2 b where a.id=b.id; ugly way

[sqlite] difference between sqlite3_reset() and sqlite3_clear_bindings()

Can someone please explain the difference between sqlite3_reset() and sqlite3_clear_bindings() and when would I use one over the other. I've read the 3.2.2 docs and it's not 100% clear to me. Thanks

[sqlite] conditional queries against views

Can anyone explain why these queries don't work? And, is there a workaround? create table t1 (id int); create table t2 (id int, name varchar(32)); create view v1 as select a.id, b.name from t1 a, t2 b where a.id=b.id; select * from v1 where a.id=1; select * from v1 where t1.id=1; select *

Re: [sqlite] freepages.c ported to sqlite v3. Request feedback.

On Thu, 7 Jul 2005, Dennis Jenkins wrote: >Hello. > >Several months ago I ported the "free pages" code from sqlite v2 to >v3. I found the original at [1]. My copy is at [2]. I unsuccessfully >tried to contact the original author. > >This code simply computes the amount of "slack space"

[sqlite] freepages.c ported to sqlite v3. Request feedback.

Hello. Several months ago I ported the "free pages" code from sqlite v2 to v3. I found the original at [1]. My copy is at [2]. I unsuccessfully tried to contact the original author. This code simply computes the amount of "slack space" in the database. Our database will sometimes

Re: [sqlite] My first post, a few wishes..

Edwin Knoppert wrote: I'm not using c and thus i do not compile the source into my app :) So i'm calling sqlite3_get_table() to obtain data. It's purely to instruct the sqlite 3 dll, think as if i'm where using VB6 (without some 'odd' wrapper/helper dll's) I'm actually using PowerBASIC -

Re: [sqlite] Memory Allocated

On Wed, 6 Jul 2005, John Dean wrote: >At 13:53 06/07/2005, you wrote: >>On Wed, 2005-07-06 at 09:38 -0300, Gerson Luís Fontoura Vaz wrote: >> > I'm using SQLite for the first time... >> > >> > We are using SQLite version 2.8.15. >> > >> >>Why, oh why are you using 2.8.15 when 3.2.2 is known to

Re: [sqlite] My first post, a few wishes..

I'm not using c and thus i do not compile the source into my app :) So i'm calling sqlite3_get_table() to obtain data. It's purely to instruct the sqlite 3 dll, think as if i'm where using VB6 (without some 'odd' wrapper/helper dll's) I'm actually using PowerBASIC - PB/WIN80. I'm also having

Re: [sqlite] My first post, a few wishes..

Edwin Knoppert <[EMAIL PROTECTED]> writes: > Sorry, i seem to have posted to another thread somehow.. > > No you misunderstood me, i'm well able to obtain the fields but it seems not > to have the fieldnames when no rows where inserted. I think what you're looking for is PRAGMA

Re: [sqlite] My first post, a few wishes..

Sorry, i seem to have posted to another thread somehow.. No you misunderstood me, i'm well able to obtain the fields but it seems not to have the fieldnames when no rows where inserted. ? - Original Message - From: "Kiel W." <[EMAIL PROTECTED]> To: Sent:

RE: [sqlite] My first post, a few wishes..

I took it to mean that he wants: SELECT sql FROM sqlite_master WHERE type='table'; But I could be wrong. -Original Message- From: Kiel W. [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 8:52 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] My first post, a few wishes.. On

Re: [sqlite] My first post, a few wishes..

On 7/7/05, Edwin Knoppert <[EMAIL PROTECTED]> wrote: > > 1) I wish for a better way to recreate a table's definition. > The FAQ example is no good if you are unknown to it's fields. > For example, imy dbms obtains the create table query for the user, he might > want to reset table name as add or

Re: [sqlite] Questions about VDBE, deadlocks and SQLITE_BUSY

On Thu, 2005-07-07 at 12:56 +0200, Gerhard Haering wrote: > - is it true that after sqlite3_prepare, only the first call to > sqlite3_step can return SQLITE_BUSY, or can subsequent calls also > return SQLITE_BUSY? > Yes. I think this is true. At least I cannot think of any path by which

[sqlite] Questions about VDBE, deadlocks and SQLITE_BUSY

Some pysqlite users are experiencing problems with locks not going away, as described in http://www.third-bit.com/trac/argon/wiki/Locking In order to fix this, I need some information: - is it true that after sqlite3_prepare, only the first call to sqlite3_step can return SQLITE_BUSY, or can

[sqlite] My first post, a few wishes..

1) I wish for a better way to recreate a table's definition. The FAQ example is no good if you are unknown to it's fields. For example, imy dbms obtains the create table query for the user, he might want to reset table name as add or remove fields. After that the copy as suggested in the FAQ