[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

[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

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

[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

[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] 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]

[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

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] [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

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

[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,

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] 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