On Apr 16, 2009, at 6:44 AM, galeazzi-at-korg.it |sqlite| wrote:
> I tried to use (const char*)sQuery.c_str() but it doesn't work. Any
> ideas?
That won't work because std::wstring.c_str() returns wchar_t* not char*.
One way would be to convert your std::wstring to an std::string in
UTF-8
Interestingly this is only a problem if I build our app debug. I'm
guessing the release build optimizes out the else clauses because it
can see that isNT() is defined as "1".
___
sqlite-users mailing list
sqlite-users@sqlite.org
I am getting 4 link errors when compiling for our Windows CE 5
platform with the amalgamated version of 3.6.4. They are for
CreateFileA, GetFileAttributesA, DeleteFileA and LoadLibraryA.
From looking at the code, isNT() is defined to 1 for CE, and the
above four functions are in else
In case anyone's following along and would care to comment it seems
like what's happening is:
1. One connection does a DROP TABLE then CREATE TABLE, in back-to-back
calls to sqlite3_exec.
2. Another connection does a sqlite3_get_table, which calls
sqlite3_exec, which calls sqlite3_prepare,
I found that it is actually a call to sqlite3_get_table that is
returning this error, not sqlite3_exec as I had originally thought.
Does that make the cause of getting SQLITE_SCHEMA any easier to
pinpoint?
___
sqlite-users mailing list
On Oct 15, 2008, at 10:11 PM, Roger Binns rogerb-at-rogerbinns.com |
sqlite| wrote:
> The main cause of them failing is if the statement becomes
> invalid. One example would be if it uses a collation that was
> unregistered.
I only use sqlite3_exec, so I don't keep prepared statements
I have an application that uses SQLite 3.5.7. I have recently started
seeing occasional SQLITE_SCHEMA errors being returned by
sqlite3_exec() that I don't understand.
The application doesn't do ALTER TABLE. It creates the database file
afresh on each run (it's created in a RAM file system).
On Apr 22, 2008, at 7:57 PM, Joanne Pham joannekpham-at-yahoo.com |
sqlite| wrote:
> Hi all,
> I have the serveral sql statement in the one file call : getData.sql
> and
> I want to use the sqlite API to call this file to execute all sql
> statements in this file at once.
>
> Can you tell
On Apr 22, 2008, at 6:52 PM, Igor Tandetnik itandetnik-at-mvps.org |
sqlite| wrote:
> Have thread B let thead A know that it wants in by using some
> synchronization primitive. E.g on Windows I'd use a manual reset
> event.
> Thread A waits on the event at the top of the loop. The event is
On Apr 22, 2008, at 6:52 PM, Scott Hess shess-at-google.com |sqlite|
wrote:
> Weirdo response, but ... make sure you have HAVE_USLEEP defined. We
> kept seeing something similar, and kept looking at the code for
> sqliteDefaultBusyCallback(), and the code looked right, but the
> problem
I am using SQLite 3.5.7. This is a simplified example, but I have 2
threads in the same process, each with their own connection, and cache
sharing disabled.
Thread A does:
while (some condtion)
BEGIN IMMEDIATE
do some INSERTs
COMMIT
Thread B occasionally wants to
>>
> I don't know for sure, but I suspect it would be the same. It seems
> like
> it should be simple enough to try it out both ways.
>
> Dennis Cote
It seems too, and the description in the help implies that it does,
but I wanted to double check. I have logic that reacts based on that
On Apr 17, 2008, at 5:05 PM, Fin Springs 20dkom502-at-sneakemail.com |
sqlite| wrote:
> If I do:
>
> sqlite3_exec(..."UPDATE foo..."...)
>
> and then:
>
> numChanges = sqlite3_changes()
>
> I get the number of updated rows back. My question is, if I chang
If I do:
sqlite3_exec(..."UPDATE foo..."...)
and then:
numChanges = sqlite3_changes()
I get the number of updated rows back. My question is, if I changed
the statement in the single exec call to "BEGIN IMMEDIATE;UPDATE
foo...;COMMIT", will sqlite3_changes still return the same value as
On Apr 4, 2008, at 11:11 AM, Dennis Cote dennis.cote-at-. |
sqlite| wrote:
> Why do you need two transactions in parallel? In general only one
> connection can have a transaction open on a database at any time.
> Locking is used to serialize transactions. Even with two connections,
> you
Is it possible to open multiple connections to an in-memory database?
I have an application that gets a db handle with
sqlite3_open(":memory"). If another thread in the application were to
make that same call, would it get the same handle, another handle to
the same in-memory database, or a
Is it possible to open multiple connections to an in-memory database?
I have an application that gets a db handle with
sqlite3_open(":memory"). If another thread in the application were to
make that same call, would it get the same handle, another handle to
the same in-memory database, or a
On Feb 23, 2008, at 9:15 PM, Sam Carleton scarleton-at-
miltonstreet.com |sqlite| wrote:
> How do I compile a C program to use the shared DLL rather then
> statically link in SQLite?
Good question; the DLL download only has the DEF file and the DLL, but
you normally need an export LIB file to
>> Is there a recommended way to run the tests on CE? I created a
>> VisualStudio project for sqlite3 but ran into some problems:
>>
>> 1) I couldn't see a way to generate sqlite3.h. I ended up using
cygwin
>> with configure then make to get me sqlite3.h, parse.h, opcodes.h and
>>
> This query returns a boolean result and stops as soon as it has
> determined the result
> select exists (select * from contacts where contacts_phone_tel glob
?);
> HTH
> Dennis Cote
I have been using:
SELECT NULL FROM sqlite_master WHERE type='table' AND lower(name)=?
to determine whether
> Can somebody with the ability to compile and test for wince
> please test check-in [4802] for me.
Is there a recommended way to run the tests on CE? I created a
VisualStudio project for sqlite3 but ran into some problems:
1) I couldn't see a way to generate sqlite3.h. I ended up using cygwin
> For that matter, is there anybody out there who would like
> to become the official wince maintainer for SQLite? If you
> are able to compile, test, and debug SQLite for wince and
I could do that if you'd like Richard.
We develop our own Windows CE 5.0 based device so I have access to
Platform
> Here's a link to an WinCE port: http://sqlite-wince.sourceforge.net/
Is there a reason to use this port any more? The straight 3.5.6
amalgamation compiles and runs fine for me on Windows CE 5.0 and
includes specific '#if OS_WINCE' sections for CE (to define localtime,
etc).
> Subject: [sqlite] Can more than one user connect to an in-memory
database?
> I don't see how. Any clues?
You could share the sqlite3* handle from the process that opens that
in-memory database, through some mechanism of your own. Since all your
users would be using the same connection, you
On Feb 15, 2008, at 5:40 PM, C S usmsci-at-yahoo.com |sqlite| wrote:
> hi all i have a question regarding Blobs, that is
> storing images into the database.
>
> my image by default is an unsigned short array and to
> bind blobs it wants a byte array. i am not sure i am
> doing this right at all.
> I'm not sure I understand the problem. The "zeroth" > row sqlite3_get_table
> returns reports column
> names. Isn't that sufficient?
Thanks Igor,
Please ignore my idiocy. I had quite forgotten they were in the 0th row.
Apologies for the time waster.
Dave
Is it possible to map column names to indices for sqlite3_get_table?
I could use sqlite3_prepare with my statement string and then calls to
sqlite3_column_name() to build a mapping. I could then dispose of the prepared
statement and make my call to sqlite3_get_table, relying on the column
27 matches
Mail list logo