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
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
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
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 around.
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
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 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 me what
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
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 remained,
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 set
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 changed
the statement in the single exec call
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
returned
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
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 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
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
keywordhash.h and
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
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 a
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 would
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. is
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
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
27 matches
Mail list logo