Re: [sqlite] SQL Quick Review/Reference

Mike Owens wrote: >> Mike Owens wrote: >> > I've been lobbying Apress to release the book in electronic form for >> > free. >> That seems a bit extreme > I wasn't referring to releasing the book as an exclusive solution to > the index problem, but rather for the community and SQLite in

Re: [sqlite] SQL Quick Review/Reference

metro wrote: > is this what everybody is looking for?? > http://booksforpeople.blogspot.com/2008/03/definitive-guide-to-sqlite-free-book.html > there are other sources for free ebooks > > Laurie > It did the rounds on alt.binaries.e-book.technical last year. The buyer's email address had been

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] sqlite3 & importing mysql-dumps: "SQL error: database disk image is malformed"

Martin Jenkins wrote: v00d00 dave wrote: Martin Jenkins schrieb: CREATE TABLE `blacklist` ( `blcfid` int(11) NOT NULL default '0', `blndid` int(11) NOT NULL default '0', PRIMARY KEY (`blcfid`,`blndid`) ) TYPE=MyISAM; If you run the sqlite3 command line utility and .read your script

Re: [sqlite] all

It's all in the mail headers: List-Post: List-Help: List-Unsubscribe: List-Subscribe: Make sure you send the request from the address that receives the mail... ;) Martin -

Re: [sqlite] LIKE and GLOB bug with numbers?

f,\n234881026,\n294022,\n2004-12-16 10:11:45 -0800,\ntciuro,\n384,\n2006-03-26 08:46:55 -0800,\n 502,\n20\n)'),) ] Could you try reducing your search strings and see if there's a point at which they start working? HTH, Martin Jenkins XQP Ltd Ascot, UK - Origi

Re: [sqlite] Error when matching column names in a view

FWIW, I can confirm that exactly the same thing happens here with the prebuilt sqlite 3.3.4 (on Windows XP SP2). It's not quite the same with the prebuilt 2.8.17 binary though - the "select id from three;" query doesn't give an error there. What is odd is that if you turn the column headers on

Re: [sqlite] last modified time or version of sqlite database

Near the bottom of http://sqlite.org/pragma.html you'll find: "PRAGMA [database.]user_version; PRAGMA [database.]user_version = integer ; The pragmas [...] user_version are used to set or get the [...] user-version, [which is a] 32-bit signed integers stored in the database header. [...] The

Re: [sqlite] last modified time or version of sqlite database

Ignore this bit - cut and paste error con=apsw.Connection("aaa") con=apsw.Connection("temp") Martin

Re: [sqlite] Strange Behaviour on Solaris 8 on Sparc

Are those directories on the same disk/partition? What do the results look like if you replace "| sqlite" with "> /dev/null"? I'm not 100% sure that you're timing the sqlite part here. I think you're timing the cat, hence my earlier comments. Try "time sqlite < /export/home/ykphuah/test.sql"

Re: [sqlite] how to recover a corrupted database?

Memtest86 is rather old now. Memtest86+ is an updated version (supports newer CPU/chipset features) and can be found at http://www.memtest.org/ HTH Martin - Original Message - From: "Jay Sprenkle" <[EMAIL PROTECTED]> To: Sent: Thursday, June 08, 2006 9:01

<    1   2   3