[sqlite] Exporting MS Access MDB into SQLite

SQLite Users, I started to export an Access MDB file into a DB file that was created with SQLite. I was using the Visual Basic, Visual Data Manager tool to export tables to the SQLite DB using the SQLite ODBC driver. The first table went OK. All other tables after that came up with the

RE: [sqlite] RegEx w/ sqlite, yet?

If you are working with delphi, I could have a solution for you. > -Original Message- > From: Jay [mailto:[EMAIL PROTECTED] > Sent: Saturday, March 26, 2005 3:41 AM > To: sqlite-users@sqlite.org; Win a 2 > Subject: Re: [sqlite] RegEx w/ sqlite, yet? > > > > Hello sqlite-users, > > >

[sqlite] Strange select performance

Hi, I have a simple table like CREATE TABLE RecipeIngredients ( id integer primary key, recipeid integer(10), unitId integer(10), ... ); With an index on recipeid and unitid (foreign keys) In the table there are 11 rows where recipeid is "558134" and 243042 rows

Re: [sqlite] Comiling static libraries on Win32

Eugene Wee wrote: Hi, Just a guess here, but wouldnt the idea then be to (manually) compile each source file, then link the object files with your own? That idea would -mostly- work, and I would hope that I have enough mental capacity to drop out the tcl bindings, dll-specific functions and the

Re: [sqlite] Comiling static libraries on Win32

Hi, Just a guess here, but wouldnt the idea then be to (manually) compile each source file, then link the object files with your own? With MinGW/GCC I used dlltool to get obtain libsqlite3.a from sqlite3.dll and sqlite3.def, passing the -lsqlite3 parameter to GCC at link-time. The only file I

[sqlite] Comiling static libraries on Win32

I highly suspect that I'm being a dolt here, but I'm not seeing the obvious thing. I downloaded the preprocessed Win32 source code in hopes of compiling a static library for a Win32 release of a project that I'm working on. Unfortunately I couldn't find a makefile in the preprocessed .zip

Re: [sqlite] Prepared Statement Interface

Eugene Wee wrote: But I'm still curious as to the delimiter thing, hope someone can clarify. Oh, and also, does sqlite3_prepare() ask for the length of the statement string in bytes including the null terminator, or excluding it? Or is it safe to use -1 most of the time? The delimiter thing