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

2005-10-13 Thread Mark Anderson
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:

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

2005-10-13 Thread Florian Weimer
* 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

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

2005-10-13 Thread Dan Kennedy
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

Re: [sqlite] 3.2.7 and russian characters

2005-10-13 Thread drh
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

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

2005-10-13 Thread Christian Smith
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

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

2005-10-13 Thread Christian Schwarz
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

Re: [sqlite] windowing functions != recursive functions

2005-10-13 Thread Andrew Piskorski
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

Re: [sqlite] windowing functions != recursive functions

2005-10-13 Thread Andrew Piskorski
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

[sqlite] drop statement returns SQLITE_ERROR

2005-10-13 Thread Preston Zaugg
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

Re: [sqlite] drop statement returns SQLITE_ERROR

2005-10-13 Thread drh
"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.

Re: [sqlite] windowing functions != recursive functions

2005-10-13 Thread pilot pirx
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

[sqlite] Newbie Question

2005-10-13 Thread JohnD
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

Re: [sqlite] Newbie Question

2005-10-13 Thread Robert L Cochran
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

Re: [sqlite] Newbie Question

2005-10-13 Thread Robert L Cochran
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

[sqlite] detecting database corruption?

2005-10-13 Thread Wilson Yeung
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

Re: [sqlite] drop statement returns SQLITE_ERROR

2005-10-13 Thread Preston Zaugg
"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.

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

2005-10-13 Thread Christian Schwarz
> 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