Re: [sqlite] delete record fail when disk full

At 11:59 AM +0800 5/27/04, Kei wrote: Is it a normal condition if no space to do the delete operation?or is it a bug?how to solve it if it has solution? Thx a lot! I am running it in arm_linux and I use sqlite version 2.8.12. temp_store is 3 in sqliteInt.h (use memory). While performing any chang

[sqlite] delete record fail when disk full

Hi all, I want to delete a record when database is full but I get the error message "../../src/sqlite/pager.c:559: pager_playback_one_page: Assertion `pPg->nRef==0 || pPg->pgno==1' failed." or "SQL error:databse is full" The sequence of doing the test: 1. create the db file and insert records u

[sqlite] About porting sqlite to my 32-CPU 4510 running uClinux

hi , sir I use ./configure and i tried to modify the generated Makefile , but it cannot achieve my goal now... In the Makefile, there are BCC and TCC, from the words there , i think the TCC is for the target, so my work is : # C Compiler and options for use in building executables that # wil

Re: [sqlite] [ANN] QuickLite 1.0 is available

On May 26, 2004, at 1:30 PM, Tito Ciuro wrote: Hello everybody, Today I'm releasing QuickLite, a Cocoa wrapper for SQLite, the embeddable SQL database engine. Very nice Tito. I just downloaded this and started poking around. Wow. This could be the start of something that might fill a nice void o

Re: [sqlite] Improvements in SQLITE 3

At 1:52 PM -0300 5/26/04, Marcelo Zamateo wrote: Hi! Is there a list of improvements coming in SQLITE 3? Is there a target date to it release? Thanks! MZ SQLite 3 will be released by Richard to the public in July. At that time should a complete feature list also appear. Meanwhile it is under de

[sqlite] Upgraded from 2.8.6 to 2.8.13

Hi , I upgraded sqlite version from 2.8.6 to 2.8.13. And I am running into a problem where after inserting and deleting some (eg 30 ) entries, I get the error, "database is full" followed by "database disk image is malformed ". I use sqlite_exec to run all queries. The database has a table

Re: [sqlite] Examples of SQL available?

Joseph Stewart >> What I'm looking for is a good set of SQL examples for more esoteric feature (to me at least) of sqlite Some good online tutorials on SQL: http://www.geekgirls.com/menu_databases.htm http://sqlzoo.net/ http://philip.greenspun.com/sql/ Fred.

[sqlite] Examples of SQL available?

Hello all, I hope I've not missed something in the sqlite web pages or mailing list. What I'm looking for is a good set of SQL examples for more esoteric feature (to me at least) of sqlite. Some topics I'd like to understand are: triggers constraints I have Celko's "SQL for Smarties" book, ala

Re: [sqlite] numrows

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 26 May 2004, Randy J. Ray wrote: From the DBI manpage: "rows" $rv = $sth->rows; Returns the number of rows affected by the last row affecting com- mand, or -1 if the number of rows is not known or not availa

[sqlite] [ANN] QuickLite 1.0 is available

Hello everybody, Today I'm releasing QuickLite, a Cocoa wrapper for SQLite, the embeddable SQL database engine. QuickLite already includes SQLite, so there's no need to download and to configure. It provides the developer with a SQL database without running a separate RDBMS process. QuickLite i

Re: [sqlite] equal to expression returning incorrect results

- Original Message - From: "Kurt Welgehausen" <[EMAIL PROTECTED]> > No one can really evaluate this without knowing your view > definition. Here you are. I'm still not sure that it is relavent though. CREATE VIEW Device_Property_List AS SELECT D.device_id AS device_id,

[sqlite] Tips & tricks for concurrency?

Hi, I did read the archives, along with information on the web site, and am aware of the risks I take using SQLite in concurrent mode. Still, since over half of our customers still don't have the Net (hence, usually use NetBeui as their network protocol instead of TCP/IP), and asking them to hav

Re: [sqlite] numrows

H. Wade Minter wrote: In DBD::SQLite, what's the proper way to get the number of rows returned by a query? for example: $query = "SELECT * FROM foo WHERE bar LIKE '%baz%'"; $sth = $dbh->prepare($query); $sth->execute; $numrows = $sth->rows; # DOES NOT WORK, ALWAYS RETURNS -1 From the DBI manpage:

Re: [sqlite] need help about porting to embedded system

Hello, I was faced with a similar problem a few weeks ago. There is a website that has pre-compiled packages for other architectures. They have a sqlite and libsqlite package which I installed on my mobile device. http://ipkgfind.handhelds.org/ It's down for now I think, but try again whe

[sqlite] Improvements in SQLITE 3

Hi! Is there a list of improvements coming in SQLITE 3? Is there a target date to it release? Thanks! MZ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] equal to expression returning incorrect results

No one can really evaluate this without knowing your view definition. You can begin to investigate it by adding 'device_property_id=26' to the where clause of the select statement in your view definition. Then see if the select will execute correctly, or if it even makes sense. Regards

[sqlite] equal to expression returning incorrect results

Hi All, I have been testing a view which uses a fairly complex join between several tables and nested case expressions to select the desired value to be retruned. I believe this working as expected. I am getting an unexpected result when I try to apply a WHERE condition to one of the returned col

[sqlite] need help about porting to embedded system

hi, sir I'm engaged in porting sqlite to my S3C4510 32-bit CPU, and the system is uClinux, but it cannot work in the system , can anybody make suggestions? thank you ! zhengwei [EMAIL PROTECTED] 　　2004-05-26

[sqlite] Triggers and performances

Hi, I'm using triggers to perform some operations on my SQLite DB. Particularly I'm using them to easily maintain DB coerency (e.g. if I delete an item from a table, the trigger will delete all rows from another table that are referencig to that item). My question is: how much performant the tri

[SOLVED]: [sqlite] Problems adding a new column

Hello Paul, You just beat me by a couple minutes! :-) Thanks, I've found out this statement works as well: -> INSERT INTO address_backup(ROWID,First,Last,Country) SELECT ROWID,First,Last,Country FROM address; Thanks a lot, -- Tito On 26 may 2004, at 9:15, Paul Smith wrote: Shouldn't the INSER

Re: [sqlite] Problems adding a new column

At 14:03 26/05/2004, Tito Ciuro wrote: Hello, I would like to add a new column to an existing table on-the-fly. I've followed the code found on SQLite's website: http://sqlite.org/faq.html#q13 and modified it slightly to the following: Adding table 'address' to the database... -> CREATE TABL

[sqlite] numrows

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [Apologies if this goes to the list twice - I had email issues last night and couldn't tell if it went through] In DBD::SQLite, what's the proper way to get the number of rows returned by a query? for example: $query = "SELECT * FROM foo WHERE bar LI

[sqlite] Problems adding a new column

Hello, I would like to add a new column to an existing table on-the-fly. I've followed the code found on SQLite's website: http://sqlite.org/faq.html#q13 and modified it slightly to the following: Adding table 'address' to the database... -> CREATE TABLE address(ROWID INTEGER PRIMARY KEY,Fi