Nothing wrong with SQLite.
The compiler is unable to convert a long long to a double.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
"Rich Rattanni" <[EMAIL PROTECTED]> wrote:
> All:
> I am able to consistently cause the following message during a integrity check
>
> Page xxx is never used
>
> This seems non-critical, since a vacuum clears this up. If someone
> has the time could you explain the meaning (besides the obvious),
Vincent Vega wrote:
> Thanks a lot . Your explantion does make sence.
> I'll remove the UNIQUE index and see if it helps.
>
You probably shouldn't remove the index, just remove the unique keyword
from the create index statement.
create index InventoryIndex on Inventory (Tag);
If you have an ex
All:
I am able to consistently cause the following message during a integrity check
Page xxx is never used
This seems non-critical, since a vacuum clears this up. If someone
has the time could you explain the meaning (besides the obvious),
causes, and dangers of receiving this message during a i
Bharath Booshan L wrote:
>
> Table File:
> -
> FileID INTEGER PRIMARY KEY Auto Incrment
> FullPathTEXT
> FileNameTEXT
> CreationDateREAL
> ModifiedDateREAL
>
>
> Table Segments:
> ---
Dennis ,
Thanks a lot . Your explantion does make sence.
I'll remove the UNIQUE index and see if it helps.
Vincent.
- Original Message
From: Dennis Cote <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database
Sent: Monday, March 17, 2008 4:27:11 PM
Subject: Re: [sqlite] SQLITE_CO
MarcoN <[EMAIL PROTECTED]> wrote:
> Hello, everybody.
>
> I have the following problem: I have an old project that uses a database
> created with an older SQLite library version.
> Now, since I updated SQLite to 3.5.5, I can't use the database anymore,
> because any query on the database tables re
Do you test for SQLITE_BUSY, when you perform BEGIN IMMEDIATE ?
Yes a process that is reading will continue to read. Once it completes if
anothre process is waiting to write then the additional read locks will not be
granted. This is to prevent writer starvation.
How do you know that the dat
On Fri, 14 Mar 2008 20:10:36 -0700 (PDT), you wrote:
>In testing a my code I came across this example.
>Could someone help me understand what this syntax is doing please
>(from the Seinfeld demo database examples)
I assume this is syntax for the command line tool:
>..m col
>..h on
>..w 20 17 6 2
How are you synchronizing your updates and reads? It looks like you may
be missing a COMMIT.
Bharath Booshan L wrote:
> Ken,
>
> Thanks for reply,
>
>
>>I would start with APP A to determine after processing that the data that you
>>asked to be loaded is actually loaded. If it does not, then
Hello, everybody.
I have the following problem: I have an old project that uses a database
created with an older SQLite library version.
Now, since I updated SQLite to 3.5.5, I can't use the database anymore,
because any query on the database tables returns:
SQLite error 11 - Malformed database s
> You will have to provide more detail about what you are doing to change
> the database. Since you say process A is the only one that write to the
> database, you would probably be best to post the actual code, or at
> least the actual SQL statements, that you are using in that process
Ok. Here i
Dennis Cote wrote:
> Derek Developer wrote:
>> Could someone help me understand what this syntax is doing please
>> (from the Seinfeld demo database examples)
>>
>
> What Seinfeld demo database examples?
>
The book "The Definitive Guide to SQLite" by Michael Owens (ISBN
1-59059-673-0) examples
Ken,
Thanks for reply,
> I would start with APP A to determine after processing that the data that you
> asked to be loaded is actually loaded. If it does not, then look into app A.
>
I think I need to add some more information here.
App B will be in running state, and whenever a write operati
That search is currently in process.
Lee
_
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jay Sprenkle
Sent: Friday, March 14, 2008 4:36 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Efficiency Question - Val
Dima Dat'ko wrote:
> Sorry for the long introduction. Here is the question. Am I right
> there is no option defined to have the stmtjrnl file in memory or in
> some specified path other then the same folder as the db? It's
> critical to prevent the db corruption in all kinds of software and
> hard
Bharath Booshan L wrote:
>
> I will give overview of what is happening
>
> App A - Writer process
> ---
> * Open SQLIte Connection
> * BEGIN IMMEDIATE TRASACTION
> * Insert/Update some 1000 rows in Table A,B,C
> * COMMIT
> * Close SQLite connection
> -
Function sqlite3_last_insert_rowid always returns 1.
I have compiled SQLite for ARM big endian mode using the gcc ARM compiler.
I have also compiled SQLite for the Axis ETRAX RISC processor.
The two platforms we are using are the Linksys NSLU2 (the unslung
firmware) and Acme systems FOX Board:
I would start with APP A to determine after processing that the data that you
asked to be loaded is actually loaded. If it does not, then look into app A.
If app A data load succeeds (and is correct in that all data loaded).
Run app B. If this errors out you more than likely have a query related
Derek Developer wrote:
> Could someone help me understand what this syntax is doing please
> (from the Seinfeld demo database examples)
>
What Seinfeld demo database examples?
> ..m col
> ..h on
> ..w 20 17 6 23 6
> ..e on
>
> Is this some form of typecasting?
There isn't enough information he
Vincent Vega wrote:
> Anyhow, as I said before the code works fine most of the times(I can
> insert 500 records to the table and read them correctly) but from time
> to time I get SQLITE_CONSTRAINT error code after the sqlite3_step.
> Any Idea why?
>
> Here are the table defenitions :
> CREATE TAB
Same here
On 3/14/08 7:17 PM, "P Kishor" <[EMAIL PROTECTED]> wrote:
> I have now twice gotten the following message. What gives?
>
>
> This is the mail system at host sqlite.org.
>
> I'm sorry to have to inform you that your message could not
> be delivered to one or more recipients. It's att
Hello List,
Here I am stuck with some Database Table corrupt problem and I would
request the people on this list to help me out as I am unable to figure out
the cause for this problem.
Previously I was using SQLite 3.1.3 and now since our application should
support Mac OS Leapord, it uses SQLi
Hello, sqlite-users
i want to be the user member of sqlite.please let me in ,3x so mush!
dongsheng zhang, [EMAIL PROTECTED]
2008-03-17
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>But I need my rowid to be chaged as follows.
>
>Rowid Id Name
>1 4 aaa
>2 3 bbb
>3 2 xxx
>4 1 zzz
You can't.
Rowid isn't an index of where the row appeared in the results, it's a
'hidden' field in each row in the table.
Why do you need your rowid to be changed?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mahalakshmi.m
Sent: Friday, March 14, 2008 1:03 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Rowid After Sorting
Hi,
I am working in 3.3.6 and my table looks
Dear List,
I faced with critical performance problem on a WinCE device when db
resides on it's slow built-in flash card (Windows CE .Net Version
4.20, processor Intel PXA255, some Toshiba obsolete compact flash
card, C++ application using SQLITE API directly).
Our application uses SQLite for coll
Well, I'm not sure what you are trying to do that you can't do with SQL.
I'll assume that you really want to iterate over all rows of ( a single
table? ) and conditionally update a field? If so, wouldn't a
"update tablename set [Classification]='Retired' where [Age]>65" do what
you need?
-Orig
Hello List,
Here I am stuck with some Database Table corrupt problem and I would
request the people on this list to help me out as I am unable to figure out
the cause for this problem.
Previously I was using SQLite 3.1.3 and now since our application should
support Mac OS Leapord, it uses SQLit
Hello List,
Here I am stuck with some Database Table corrupt problem and I would
request the people on this list to help me out as I am unable to figure out
the cause for this problem.
Previously I was using SQLite 3.1.3 and now since our application should
support Mac OS Leapord, it uses SQLite
30 matches
Mail list logo
