[sqlite] [SQLite] Variations in DLLs

My simple Delphi test of libSQL worked fine, creating a database file, executing some SQL, returning the DLL version. Used the same code in my app framework, however, and everything kept coming up dead: no file created, no error reply, no version message. The difference turned out to be the

Re: [sqlite] SQLite 3.0.8 dates

On Fri, 4 Feb 2005 12:09:59 -0800 (PST), you wrote: >I've been agonizing over the best way to store date/time >values in my databases (perl will be the app platform). > >So, my question is, true or false:, if I want to use >SQLite's date/time functions against field values, my only >real option

Re: [sqlite] still struggling with "Database schema has changed" errors

>Do mind sharing or explaining your changes? No.. But I should have gave more information. My changes were for the TCL SQLITE code, and just affected the way TCL accesses the library. I was also getting the schema errors when I was using a single threaded app. I was opening two instances but

Re: [sqlite] still struggling with "Database schema has changed" errors

Wow that's a lot different than what I read in some of the messages I read in the archive. I read that we're not suppose to see SQLITE_SCHEMA errors in SQLite3 unless something very wrong happened. Thanks, Kervin Dan Kennedy wrote: There's a little bit written about SQLITE_SCHEMA errors here:

Re: [sqlite] compiled features at runtime? - Re: [sqlite] still struggling with "Database schema has changed" errors

Jeff Thompson wrote: The way THREADSAFE works currently, is that it must be defined, but also must have a value assigned to it. The compiler switch /D THREADSAFE won't cause sqlite to have thread safe code included, whiel /D THREADSAFE=1 will. Ensure you're using the latter format, or That was at

Re: [sqlite] still struggling with "Database schema has changed" errors

There's a little bit written about SQLITE_SCHEMA errors here: http://www.sqlite.org/faq.html#q17 --- "Kervin L. Pierre" <[EMAIL PROTECTED]> wrote: > Hi, > > Thanks for your response. I'm at wit's end > with this thing. > > I do open the database multiple times, but > exactly once per

Re: [sqlite] compiled features at runtime?

On Fri, 04 Feb 2005 16:54:31 -0500, Kervin L. Pierre <[EMAIL PROTECTED] > wrote: Thanks for your response Chris. Is there a way to find out what components are compiled in at runtime? I don't believe the way the THREADSAFE define is handled today would allow you to

Re: [sqlite] compiled features at runtime? - Re: [sqlite] still struggling with "Database schema has changed" errors

On Fri, 04 Feb 2005 16:54:31 -0500, Kervin L. Pierre <[EMAIL PROTECTED]> wrote: > Thanks for your response Chris. > > Is there a way to find out what components are > compiled in at runtime? > I don't believe the way the THREADSAFE define is handled today would allow you to check anything at

Re: [sqlite] still struggling with "Database schema has changed" errors

Hi, Thanks for your response. I'm at wit's end with this thing. I do open the database multiple times, but exactly once per thread. I then keep the sqlite3* on thread local storage and only use that pointer on the thread it was created on. This is how I interpreted the documentation. Is that

Re: [sqlite] SQLite 3.0.8 dates

Clark Christensen wrote: I've been agonizing over the best way to store date/time values in my databases (perl will be the app platform). So, my question is, true or false:, if I want to use SQLite's date/time functions against field values, my only real option is to store -MM-DD HH:MM:SS

Re: [sqlite] SQLite 3.0.8 dates

Friday, February 4, 2005, 3:09:59 PM, Clark Christensen wrote: > So, my question is, true or false:, if I want to use > SQLite's date/time functions against field values, my only > real option is to store -MM-DD HH:MM:SS time strings. > Any other value, whether MMDD, julian day number,

[sqlite] SQLite 3.0.8 shell error handling

Is there any error handling available in the SQLite 3.0.8 command shell? Using sqlite3 test.db "read my.sql" from the commandline, I don't see a way to embed an exit into the script file in case something goes wrong with one step or another. I want to use the shell read a script like this from

[sqlite] SQLite 3.0.8 dates

I've been agonizing over the best way to store date/time values in my databases (perl will be the app platform). So, my question is, true or false:, if I want to use SQLite's date/time functions against field values, my only real option is to store -MM-DD HH:MM:SS time strings. Any other

[sqlite] insert

I am currently using a sqlite 2.8 database with an SQLite.NET Provider (from http://www.eggheadcafe.com/articles/20040714.asp). When I insert data with my application (which use an connectionString specifying UTF8Encoding=True) everything goes well. But if I try to insert data with a script

[sqlite] grabbing an in-memory database

I wonder if it would be cool to be able to stream an in-memory database to a single chunk of memory, and to have SQLite initialize an in-memory database from a chunk of memory (perhaps, though, that isn't possible). That would allow you to do things like suck the entire contents of a file into