Re: [sqlite] Updating a whole column at once

On 9/27/06, James W. Walker <[EMAIL PROTECTED]> wrote: What is the fastest way to change the values in one column in every row? What I thought of was like so: BEGIN TRANSACTION; UPDATE MyTable SET TheCol=7 WHERE keyCol=1; UPDATE MyTable SET TheCol=8 WHERE keyCol=2; ... and so

[sqlite] Updating a whole column at once

th a better mental model of what the database engine is doing would easily see whether this makes sense. -- James W. Walker, ScriptPerfection Enterprises, Inc. <http://www.write-brain.com/> - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] WHERE clause syntax error

FROM A WHERE ID NOT IN (SELECT ID FROM B); works and is probably more efficient, but I'm just curious what's wrong with the first one. -- James W. Walker, ScriptPerfection Enterprises, Inc. <http://www.write-brain.com/>

Re: [sqlite] Problems compiling SQLite 3.3.4 on Mac OS X

past. I see that these symbols are defined in os.h, which is included in the project. Any ideas? The symbols are *declared* in os.h, but *defined* in os.c. Is os.c in the project? -- James W. Walker, ScriptPerfection Enterprises, Inc. <http://www.write-brain.com/>

Re: [sqlite] Novice Inserting TEXT/BLOB question

es and NULs. -- James W. Walker, ScriptPerfection Enterprises, Inc. <http://www.write-brain.com/>

[sqlite] Assertion failure in pager.c

How much should I worry about this? Assertion (pPager->ckptJSize == pPager->nRec*JOURNAL_PG_SZ(journal_format)+JOURNAL_HDR_SZ(journal_format)) failed in "pager.c", line 2128 This is in version 2.8.13. After resaving the file, the assertion no longer fails. --

Re: [sqlite] Use of alloca() in SQLite sources

Will Leshner <[EMAIL PROTECTED]> wrote: I could be wrong, but I think alloca() may not be available to CodeWarrior. No, looks like it's defined in CodeWarrior for Mac and Windows, at least in the latest version (CodeWarrior Dev. Studio 9). -- James W. Walker, ScriptPerfection Enter

Re: [sqlite] long filenames on Mac OS

uot;jrnl". Haven't had any problem with it. Note that in certain cases, SQLite also adds 20 random characters to the file name. I changed it to use 10. By the way, it is possible that you can have this problem on Mac OS X, if someone has a hard drive formatted with the old "Mac O

[sqlite] Norton AntiVirus conflict on Mac

ment above sqliteOsOpenExclusive saying that "To avoid a potential security problem, we do not allow the file to have previously existed." I'd be interested to know what that security problem is. -- James W. Walker, ScriptPerfection Enterprises, Inc. &l

Re: [sqlite] A proposal for SQLite version 3.0

unsigned short, with a separate length rather than a trailing zero. -- James W. Walker, ScriptPerfection Enterprises, Inc. <http://www.write-brain.com/> - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Bug database question: a fix that isn't really

If a bug ticket is marked "fixed", and I add a remark that it still seems to be broken, will someone notice, or is it better to create a new ticket? The ticket in question is 627. -- James W. Walker, ScriptPerfection Enterprises, Inc. <http://www.wr

Re: [sqlite] Bug database question: a fix that isn't really

You can change the status back to "active" if you want. That seems easier than creating a new ticket. And how does one do that to a ticket that was created anonymously? Note that I am not logged in, because I don't see any way to create an account on your bug-tracking syste

Re: [sqlite] Bug database question: a fix that isn't really

Will Leshner <[EMAIL PROTECTED]> wrote: Can't you just click the Edit link? Duh! I guess I just assumed that only the developers should be able to change the status of a ticket. At least, if I were writing a bug tracking system, I wouldn't let anonymous users change a stat

Re: [sqlite] Temporary table problem

Thanks! When I compiled 2.8.12, the compiler pointed out that the function "lookupName" in expr.c has a variable "db" that is referenced but never initialized. -- James W. Walker, ScriptPerfection Enterprises

[sqlite] Temporary table problem

loc(0) to be NULL. Should I patch sqliteMallocRaw, or does this indicate a problem higher up the call chain? -- James W. Walker, ScriptPerfection Enterprises, Inc. <http://www.write-brain.com/> - To unsubscribe, e-m

[sqlite] How to update a whole column

What is the fastest way to change the values in one column in every row? What I thought of was like so: BEGIN TRANSACTION; UPDATE MyTable SET TheCol=7 WHERE keyCol=1; UPDATE MyTable SET TheCol=8 WHERE keyCol=2; ... and so on for each row COMMIT; -- James W. Walker, ScriptPerfection

Re: [sqlite] Making sqlite support unicode?

s with the Latin alphabet. Are you not aware that SQLite supports UTF-8-encoded Unicode? In sqlite.h, #define SQLITE_UTF8 instead of SQLITE_ISO8859. -- James W. Walker, ScriptPerfection Enterprises, Inc. <http://www.write-