> 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
"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.
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
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
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
"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.
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
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
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
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
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
* 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
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:
13 matches
Mail list logo