Re: [sqlite] SQLite 2 to SQLite 3 - Varchar sizes

Mitchell Vincent wrote: Fantastic idea, but I'm afraid this will all be on Windows. I'll see about getting a sed-like program to distribute with my converter, though, thanks!! check out http://unxutils.sourceforge.net/ for a Win32 version of sed -- J. Scott

Re: [sqlite] SQLite 3.3.10 compilation with VC++ for Win64

tree.c(3953) : warning C4244: '=' : conversion from '__int64 ' to 'int ', possible loss of data A number of other warnings in btree.c are about a CellInfo.nKeys and BtCursor.nKey value being converted to an int. -- Scott Wilkinson --

Re: [sqlite] UPDATE query: why is that code sooo slow?

Luc Vandal wrote: Hi, Perhaps I’m not doing things correctly, but this code will take about 1 minute to execute (2400 records on a total of around 44000 records): Wrap he updates in a transaction. See http://www.sqlite.org/lang_transaction.html for the syntax. -- Scott Wilkinson MICROS