Hello Scott Hess,
>BTW, http://www.sqlite.org/cvstrac/chngview?cn=3596 fixed a sort of
>nasty fts1/2 bug. Just in case you were looking for something else to
>pick up :-).
Thanks for those fixes, they really work - as tested with sensitive German
umlauts like 'ÄÖÜäöü'.
Btw: Are there any
Do I need to use sqlite3_close if the call to sqlite3_open indicated an
error? The documentation for sqlite3_open says "An sqlite3* handle is
returned in *ppDb, even if an error occurs." So I assumed the answer is yes.
But if I try this code (on a non-existing file and no write permissions):
On 1/24/07, Jef Driesen <[EMAIL PROTECTED]> wrote:
Do I need to use sqlite3_close if the call to sqlite3_open indicated an
error? The documentation for sqlite3_open says "An sqlite3* handle is
returned in *ppDb, even if an error occurs." So I assumed the answer is
yes.
I never do, since if
Having a look at the VB wrapper dll SQLite3VB.dll from Todd Tanner at:
http://www.tannertech.net/sqlite3vb/index.htm
All working very nicely and also nice to have the option (as explained in
the tutorial) to compile the SQLite source yourself.
So, thanks Todd for making that available.
I have
On 1/24/07, Ralf Junker <[EMAIL PROTECTED]> wrote:
Hello Scott Hess,
Btw: Are there any chances that ticket #2183 could make it into 3.3.12?
It is about a nasty crash which happens to FTS2 compiled with
SQLITE_OMIT_SHARED_CACHE when many records are inserted.
Even though FTS2 is not yet
>Hi, what you'll need to do is to build sqlite2 from sources with MinGW
>(Qt4 default compiler for Windows). Once you have this built, probably
>you will get an exe file and hopefully a shared library. (look at the
>sqlite install docs for instructions on how to build sqlite library)
>I've never
I have just one question.
What exactly does this function do:
Private Declare Function sqlite3_changes _
Lib "SQLite3VB.dll" (ByVal DB_Handle As Long) As Long
It looks it will always give one, unless you have just created a database
and done nil with it. Is this how it is?
It returns the
Thanks, that makes it clear.
> SQLite implements the command "DELETE FROM table" without a WHERE clause
> by dropping and recreating the table.
Interesting, didn't know that.
Maybe I should re-create when the majority or a lot of rows are deleted.
RBS
-Original Message-
From: Trey
Thanks! This is indeed a big help. I hope to be able to get back to
this project in the next few days. The sources I got have the .def
file. Are the 'development headers' a product of the build process?
I'm not sure I'm getting your question right. If you have the sources,
you already have
> -Original Message-
> From: Leonardo Mateo [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 24, 2007 4:02 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Help for a newbie
>
> >
> > Thanks! This is indeed a big help. I hope to be able to get back to
> > this project in
It just looks that this pragma won't give me the fields and data types if
the table has no rows yet, but was just created. Is this indeed so and if so
is there a way round it?
I am trying to avoid parsing sqlite_master as I used to do that and using
this pragma is a much cleaner way to do this.
I'm not sure if this applies here, but you could try calling this first: PRAGMA
empty_result_callbacks = true;
--
Eric Pankoke
Founder / Lead Developer
Point Of Light Software
http://www.polsoftware.com/
-- Original message --
From: "RB Smissaert" <[EMAIL
I think the trouble was somewhere else and it looks that pragma works fine
Even with an empty table. Thanks for the tip in any case.
RBS
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 24 January 2007 22:56
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]
In case it is of use to any VB or VBA coders, I think this is all the code
needed to work with this dll. Also added a bit of code to do timings.
Option Explicit
Private Declare Sub sqlite3_open Lib "SQLite3VB.dll" _
(ByVal FileName As String, _
--- James Dennett <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > The proposed expression ((sqlite3_destructor_type)-1) is equivalent to
> > ((void(*)(void *))-1). They are interchangable.
>
> Not in C++. The difference being linkage; with the typedef declared in
> an extern "C" block, the
I am running MS's Application Verifier with ms visual studio 2005 on my exe in
debug mode and I get the following error when trying to do a FreeLibrary() on
the sqlite3.dll. Nothing sql wise is active that I am aware of. What is
happening in the sqlite3.dll to give this error and how can I
* Jay Sprenkle <[EMAIL PROTECTED]> [2007-01-22 15:20]:
> My understanding was that a "shared lock" is a metaphor, and
> IMHO, a fairly stupid one. If you lock a room, nobody else can
> get in, it's not a mechanism for sharing, it's a mechanism for
> preventing sharing.
Reasoning by analogy rarely
17 matches
Mail list logo
