RE: [sqlite] database disk image is malformed

2005-05-27 Thread Drew, Stephen
Sorry for the lack of information. I'm using Windows 2000, the file is on a local drive with full access permissions. I've done some checking on memory over the last few weeks, but nothing conclusive so I will give this a go. The odd thing is it happens during a piece of functionality that is

[sqlite] What is SSE?

2005-05-27 Thread Ned Batchelder
Every so often I check the CVS timeline (http://www.sqlite.org/cvstrac/timeline) to get a preview of the changes being checked in. It helps me know what to expect in upcoming releases. Lately Dan has been checking in stuff for "SSE". Do you mind if I ask: what is SSE? --Ned.

Re: [sqlite] What is SSE?

2005-05-27 Thread D. Richard Hipp
On Fri, 2005-05-27 at 09:26 -0400, Ned Batchelder wrote: > Every so often I check the CVS timeline > (http://www.sqlite.org/cvstrac/timeline) to get a preview of the changes > being checked in. It helps me know what to expect in upcoming releases. > Lately Dan has been checking in stuff for

RE: [sqlite] database disk image is malformed

2005-05-27 Thread Christian Smith
On Fri, 27 May 2005, Drew, Stephen wrote: >Sorry for the lack of information. > >I'm using Windows 2000, the file is on a local drive with full access >permissions. I've done some checking on memory over the last few weeks, >but nothing conclusive so I will give this a go. > >The odd thing is it

Re: [sqlite] how to list table making a view

2005-05-27 Thread Noel Frankinet
Dennis Cote wrote: Noel Frankinet wrote: Lawrence Chitty wrote: You may be able to do this using the 'explain' statement for example, I have a view called 'myview'. Wrapping this into an sql select statement and proceeding this with explain e.g. > explain select null from myview gives

Re: [sqlite] Newbie API questions

2005-05-27 Thread Dennis Cote
Jay Sprenkle wrote: [2] Looking at the sqlite3_bind_* APIs, I'm curious about the destructor functions, and the "special values", SQLITE_STATIC, and SQLITE_TRANSIENT. Not being a C programmer, these constants are a mystery to me. I think it'd be useful to use the sqlite3_bind_* APIs, but I

Re: [sqlite] What is SSE?

2005-05-27 Thread Cory Nelson
Wow, that is sure to cause some confusion with the instruction set! Just some friendly advice- is there a better name it could be given? On 5/27/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote: > On Fri, 2005-05-27 at 09:26 -0400, Ned Batchelder wrote: > > Every so often I check the CVS timeline >

Re: [sqlite] Newbie API questions

2005-05-27 Thread Clark Christensen
--- Dennis Cote <[EMAIL PROTECTED]> wrote: > Jay Sprenkle wrote: > > >>[2] Looking at the sqlite3_bind_* APIs, I'm curious > about > >>the destructor functions, and the "special values", > >>SQLITE_STATIC, and SQLITE_TRANSIENT. Not being a C > >>programmer, these constants are a mystery to me.

[sqlite] SQLite3 API Reference omission

2005-05-27 Thread Clark Christensen
One thing I noticed in the API ref for sqlite3_bind_text() and sqlite3_bind_blob() is there's no info describing what the fourth arg is for. After some trial and error, I discovered it's to describe the length of the string/blob in the third arg (duh!) :-) -Clark