org>
Sent: Fri, April 2, 2010 1:57:49 PM
Subject: Re: [sqlite] Possible bug in 3.6.23?
What does CMyAppClass::somefunction() do? Is it your own VFS implementation?
Pavel
On Fri, Apr 2, 2010 at 1:06 PM, Kevin M. <athlo...@yahoo.com> wrote:
> I've had problems with update queries us
I've had problems with update queries using sqlite 3.6.23 on Windows XP +
Visual Studio 2005 and am wondering if it is a bug. sqlite seems to go off
into the weeds when calling sqlite3_exec(). I've also had the same behavior
when using sqlite3_prepare_v2() + sqlite3_step() +
>> Actually I was wanting to put that into a program.
> I don't know how I guessed that but I'm feeling really smug now.
I'm feeling very amused by your smugness ;-)
>> So, is there an API or query I can run to load an sql file all in one go
>> (one transaction) without having to read in the
> Warning: From your phrasing it's possible you're thinking of putting a
> '.read' command into your program. The '.read' command is only a command to
> the command-line tool. It's not a function of SQLite, and you can't submit
> it as a query in your program.
> Simon.
Actually I was
Hopefully I'm not duplicating a question, but I looked on sqlite.org and did
not find the answer...
Will this:
BEGIN TRANSACTION;
.read somefile.sql
END TRANSACTION;
Put everything in the sql file into one transaction? Or do I need to put the
BEGIN/END TRANSACTION statements in the sql file
> Sorry I misunderstood your requirement, Kevin. I was focusing on the
>singular "a table" and "the table" in your original post, versus the plural
> "many types of structs". I thought you were looking for serialization
> approach.
> Regards
> Tim Romano
Ah, now I see from where the
Actually Tim that is not what I was asking at all. This is converting an
application from using MySQL to SQLite. All the tables are normalized already.
But instead of rewriting a large chunk of the application, I'd rather use the
implementation as is substituting only the code needed to use
> I'm confused. Do you, or don't you, want to use type names like INT1 or INT2
> to indicate the width in bytes of an integer field? If you do, you can act on
> them yourself using sqlite3_column_decltype. If you don't, the question
> remains: how do you plan to indicate the width of the field?
> Can't you just store the struct as a blob and be done with it?
No, I can't use a blob because there are other queries where I want individual
columns. Storing to and from a struct is only one part of the application.
Sorry, perhaps I should have specified that too.
> Why is 99 a 16-bit
I have a C/C++ application in which I want to store data from a struct into a
table (using SQLite 3.6.23) and later retrieve data from the table and store it
back in the struct. But, I need a general interface for this as there are many
types of structs used. So, what I have is a function
10 matches
Mail list logo
