Hi, all !
> What kind of error is closing your transaction? When SQLite hits
> an error, it usually leaves the transaction open.
i think that above it's not completed true, think you have a table
with a UNIQUE constraint, when you create a transaction and send a
insert that violates this UNI
Nicholas Bastin wrote:
> When trying to commit a transaction, I'm getting the following error
> message from sqlite3_exec():
>
> "cannot commit transaction - SQL statements in progress"
>
> Is there any way to find out what statements are in progress? Also,
> what could cause this? I can guarante
This is an interesting development for embedded system developers who
use Sqlite.
http://www.embedded.com/showArticle.jhtml?articleID=183700818
http://www.embedded.com/showArticle.jhtml?articleID=185302940
Quote -
The week before ESC Silicon Valley, the number of you who clicked on
Part 1 in "
Christian Smith wrote:
At the risk of this turning into another argument between us...
On Thu, 20 Apr 2006, John Stanton wrote:
Q How do programs get to be slow and bloated?
A One small inefficiency at a time.
It is just as inefficient to send dynamically created content through a
series of
I've looked some more at this (unfortunately using 2.8.16 although
the problem is also exhibited by 3.3.4) and the problem seems to be
in sqlitepager_commit and its call to pager_get_all_dirty_pages which
returns every page of the database as dirty and then proceeds to
write every page to d
Nicholas Bastin <[EMAIL PROTECTED]>
wrote:
When trying to commit a transaction, I'm getting the following error
message from sqlite3_exec():
"cannot commit transaction - SQL statements in progress"
Is there any way to find out what statements are in progress? Also,
what could cause this? I ca
When trying to commit a transaction, I'm getting the following error
message from sqlite3_exec():
"cannot commit transaction - SQL statements in progress"
Is there any way to find out what statements are in progress? Also,
what could cause this? I can guarantee that sqlite3_step has returned
SQ
On 20-Apr-06, at 9:10 AM, Jay Sprenkle wrote:
Just out of curiosity why is this data in the database?
I've seen very few applications where the blob is indexed or
operated upon
by the database and it's always a pain to deal with it. We always just
left binary data in the file system and store
On 4/20/06, Dennis Jenkins <[EMAIL PROTECTED]> wrote:
> Jay Sprenkle wrote:
> > Just out of curiosity why is this data in the database?
> > I've seen very few applications where the blob is indexed or operated upon
> > by the database and it's always a pain to deal with it. We always just
> > left
Dhivya wrote:
I could not add sqlite.dll to my project. When i try to add the reference, it
raises this error:
“A reference to “c:\Downloads\SQLite\SQLite.Net1.0.0\sqlite.cll” could not be added. This is not a valid assembly or COM component. Only assemblies with extension ‘dll’ and COM com
- Original Message -
From: "Dhivya" <[EMAIL PROTECTED]>
To:
Sent: Thursday, April 20, 2006 6:44 AM
Subject: [sqlite] Could not add Sqlite.dll to my project...Plz Help.
Hi Everyone,
I am a new user to SQLite.
I could not add sqlite.dll to my project. When i try to add the refere
On Thu, 20 Apr 2006, DBTools Software wrote:
>Hi,
>
>I have an application that needs to open a database in the users's personal
>folder. I noticed that in some circunstances the sqlite3_open fail as the
>filename is in UTF16 format. I don't know that in advance so I could open
>the db with sqlite
Hi,
I have an application that needs to open a database in the users's personal
folder. I noticed that in some circunstances the sqlite3_open fail as the
filename is in UTF16 format. I don't know that in advance so I could open
the db with sqlite3_open16.
The question is:
Is it safe to always us
Hi Everyone,
I am a new user to SQLite.
I could not add sqlite.dll to my project. When i try to add the reference, it
raises this error:
A reference to c:\Downloads\SQLite\SQLite.Net1.0.0\sqlite.cll could not be
added. This is not a valid assembly or COM component. Only asse
Jay Sprenkle wrote:
> Just out of curiosity why is this data in the database?
> I've seen very few applications where the blob is indexed or operated upon
> by the database and it's always a pain to deal with it. We always just
> left binary data in the file system and stored references to it in th
> >
> > sqlite3BtreeData() actually reads a prefix of the data.
> > Because of the way large blobs are stored (as a linked list
> > of disk pages) you have to start reading at the beginning
> > and read everything up to the point of interest.
>
> Random access for blobs would be ideal, but even a s
On Thu, 20 Apr 2006, Steve Bland wrote:
> We have been using SQLite ( v2.8.6 ) for a while now and as part of a
> new release were thinking of moving ahead to a more current version.
>
> But that is where the issues began. I did search the archives, but found
> noting of any real use on this. The
> We have been using SQLite ( v2.8.6 ) for a while now and as part of a new
> release were thinking of moving ahead to a more current version.
>
> But that is where the issues began. I did search the archives, but found
> noting of any real use on this. The same with the faq page and the chan
At the risk of this turning into another argument between us...
On Thu, 20 Apr 2006, John Stanton wrote:
>Q How do programs get to be slow and bloated?
>A One small inefficiency at a time.
>
>It is just as inefficient to send dynamically created content through a
>series of buffers as it is to s
On Wed, 19 Apr 2006, Joe Wilson wrote:
>--- [EMAIL PROTECTED] wrote:
>> Joe Wilson <[EMAIL PROTECTED]> wrote:
>> >
>> > If you read the blob all in at once, true.
>> > But doesn't sqlite3BtreeData() allows you to read a partial chunk of
>> > data from the blob at an arbitrary offset? This could be
20 matches
Mail list logo