[sqlite] Static library for sqlite for Windows

Hi, I have downloaded the sqlite 3.2.7. binary version for Windows. But I found no libsqlite3.lib. Can anyone help in this regard? Thanks, Lakshmi.

AW: [sqlite] Views over multiple tables and conditional selection (ticket #1134)

> Us an "AS" clause on each result column of the view in order to > assign the specific name you want to that column. That works. Many thanks! Regards, Christian

Re: [sqlite] drop statement returns SQLITE_ERROR

"Preston Zaugg" <[EMAIL PROTECTED]> wrote: > I have some updates to the schema of my sqlite database that i am trying to > apply. When i run these statements from the command line util they run fine. > when i run them from the API I get a SQLITE_ERROR on the statement that > drops a table. Thes

[sqlite] detecting database corruption?

I am currently writing software that will be shipped directly to consumers, and have SQLite embedded. The application is multi-threaded and I have: Reader-Writer Thread: begin transaction; write; write; read; write; read; end transaction; rinse-repeat Reader Thread: read; read; read For sev

Re: [sqlite] Newbie Question

Compiling the CVS checkout is really the same -- just cd into the 'sqlite' directory and follow the instructions below from the 'mkdir' onwards. Bob Robert L Cochran wrote: I think sqlite3.h is generated for you automatically as part of the build process from source code and it will be late

Re: [sqlite] Newbie Question

I think sqlite3.h is generated for you automatically as part of the build process from source code and it will be later installed for you in the include directory. You must actually compile sqlite from the source code. For Linux, why not just download sqlite-3.2.7.tar.gz (the linux source cod

[sqlite] Newbie Question

Hello, I'm new to Sqlite and am trying to create a simple C/C++ program. I've downloaded both the binary and the CVS source but can't seem to locate the sqlite3.h header file. Is there any document that details what I need to do in order to set up an environment to be able to write and comp

Re: [sqlite] windowing functions != recursive functions

Thank you and AndrewP for the pointers - very interesting read. Some clarifications. Coming from my perspective - that of R user, not an API user - it is natural to do more complicated operations in R than to try to write additional functions in C/tcl etc. I do not know how common will such att

Re: [sqlite] drop statement returns SQLITE_ERROR

"Preston Zaugg" <[EMAIL PROTECTED]> wrote: > I have some updates to the schema of my sqlite database that i am trying to > apply. When i run these statements from the command line util they run fine. > when i run them from the API I get a SQLITE_ERROR on the statement that > drops a table. These

[sqlite] drop statement returns SQLITE_ERROR

I have some updates to the schema of my sqlite database that i am trying to apply. When i run these statements from the command line util they run fine. when i run them from the API I get a SQLITE_ERROR on the statement that drops a table. These statements are selected out of an attached databas

Re: [sqlite] windowing functions != recursive functions

On Wed, Oct 12, 2005 at 09:05:26PM -0500, pilot pirx wrote: > There is no problem in computing moving average > or cumulative sum etc > with the existing SQL (or dealing with time windows > in general) - it just the SQL gets nasty - examples Except that the SQL doesn't "just" get nasty, it can

Re: [sqlite] windowing functions != recursive functions

On Wed, Oct 12, 2005 at 09:05:26PM -0500, pilot pirx wrote: > The windowing functions described in the link > are different from recursive functions. Yes, I think you're right. Your EMA example bugged me, so I fooled with it, but I couldn't come up with any way to implement EMA using plain SQL,

Re: [sqlite] Views over multiple tables and conditional selection (ticket #1134)

"Christian Schwarz" <[EMAIL PROTECTED]> wrote: > Hello! > > We're getting a "no such column" SQL error executing conditional select > statements using this view: > > CREATE VIEW ENTF as select ENTF1.new_key, ENTF1.tp_id_start, > ENTF1.tp_id_ziel, ENTF2.weg_id, ENTF2.weg_rel_nr from ENTF1, ENTF2 w

[sqlite] Views over multiple tables and conditional selection (ticket #1134)

Hello! We're getting a "no such column" SQL error executing conditional select statements using this view: CREATE VIEW ENTF as select ENTF1.new_key, ENTF1.tp_id_start, ENTF1.tp_id_ziel, ENTF2.weg_id, ENTF2.weg_rel_nr from ENTF1, ENTF2 where ENTF1.keyentf2 = ENTF2.keyentf2; These are the tables t

[sqlite] os_unix.c / vxworks

Hi, I have a problem with writing data to disk if using the unix_os.c. I get the following error. Assertion failed: pPager->journalOff==jSz, file V:/siemens/source/libraries/dbal/sqlite/pager.c, line 2113 I tried to write one record to a database table while using SQLITE_NO_SYNC. Then there is an e

RE: [sqlite] 3.2.7 and russian characters

> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 13, 2005 4:16 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] 3.2.7 and russian characters > > Slavomir Svetlik <[EMAIL PROTECTED]> wrote: > > > Why 3.2.7 version can not open da

Re: [sqlite] Share an sqlite3 struct between multiple threads

On Thu, 13 Oct 2005, Florian Weimer wrote: >* Christian Smith: > >> IMHO, SQLite should, however, only open a single file per database (based >> on inode) which should allow threads to override each others locks as the >> locks will be on a single file. > >I think you need multiple file descriptor

Re: [sqlite] 3.2.7 and russian characters

Slavomir Svetlik <[EMAIL PROTECTED]> wrote: > > Why 3.2.7 version can not open database with path that contains > > russian characters? > > > > Best regards Sergey Startsev > > I can not open database with sqlite.dll v. 3.2.7 which contains slovak > characters too. For example with 3.2.2 this

Re: [sqlite] Compile Problem - 'sqlite_compile' : undeclared identifier

The missing symbols are from sqlite version 2, not 3. --- Mark Anderson <[EMAIL PROTECTED]> wrote: > Hello All - > > I'm trying to incorporate sqlite3 into a Visual C++ project but am > having some problems > compiling the project. I'm made sure to include the sqlite3.h header and > I create

Re: [sqlite] Share an sqlite3 struct between multiple threads

* Christian Smith: > IMHO, SQLite should, however, only open a single file per database (based > on inode) which should allow threads to override each others locks as the > locks will be on a single file. I think you need multiple file descriptors, otherwise you'd have to use pread for accessing

[sqlite] Compile Problem - 'sqlite_compile' : undeclared identifier

Hello All - I'm trying to incorporate sqlite3 into a Visual C++ project but am having some problems compiling the project. I'm made sure to include the sqlite3.h header and I created a .lib file which is being linked in, but the compiler still complains with the following: c:\data\work\3pl\d

Re: [sqlite] help needed with syntax error in between.test script

It seems this issue is due to some problems with the Tcl compilation. When testing Tcl, I get a similar warning: Test file error: syntax error in expression "int(0x8000) < 0": extra tokens at end of expression while executing "expr {int(0x8000) < 0}" invoked from within "::tclt