Hi all sqlite users,
I'm using Sqlite for an application using 150 Mb databases running on
an embedded device (Honeywell Dolphin 9900) into an OSGi Java context.
I must give some real clues to my customers to fine tune Sqlite, so I
discovered among different ways to have better results PRAGMAs...
I
Hi Igor,
On 1/9/2011 11:57 PM, Igor Tandetnik wrote:
On 9/1/2011 10:24 AM, Mohit Sindhwani wrote:
I understand that the database could be either UTF-8 or UTF-16 - but
that would apply to the full DB not to a single column, right?
Right.
*many useful answers snipped*
Thank you very much!!
On 9/1/2011 10:24 AM, Mohit Sindhwani wrote:
I understand that the database could be either UTF-8 or UTF-16 - but
that would apply to the full DB not to a single column, right?
Right.
If that
is the case, would it not make the database larger if we had a lot of
content that was originally ASC
Hi All,
I apologize first if this question has its roots in my partial
understanding of unicode and the various UTF-encodings. We're using
Windows CE and SQLite3 - so far, we have only used ASCII data. Now,
we're going to store data in other languages and feel the need to go
towards unicode
On Thu, Sep 01, 2011 at 02:52:06PM +0100, Simon Slavin scratched on the wall:
> Putting this here in the hope it comes in useful for someone sometime.
>
> Have a table which has some text fields in it. For use with an old
> system the text fields had newlines in which were expressed with C
> esca
Putting this here in the hope it comes in useful for someone sometime.
Have a table which has some text fields in it. For use with an old system the
text fields had newlines in which were expressed with C escapes:
'firstline\nsecondline'. Here's how I fixed it:
UPDATE myTable SET textfield=RE
On 31 Aug 2011 at 23:24, Igor Tandetnik wrote:
> On 8/31/2011 5:56 PM, Tim Streater wrote:
>> In the above, each database is newly created as shown. What I had
>> forgotten to do was to create the "test" table in the second database
>> before copying the data. What seems to happen is that, lacki
I'm guessing you want "&(user.getPhoto()[0])" or just "user.getPhoto()"
A pointer...not the first value of your photo.
Michael D. Black
Senior Scientist
NG Information Systems
Advanced Analytics Directorate
From: sqlite-users-boun...@sqlite.org [sqli
Rafael Toledo wrote:
> rc = sqlite3_prepare_v2(mydb, "INSERT INTO users (name, isadmin,
> photo) VALUES (?, 1, ?)", -1, &statement, NULL);
> if (rc != SQLITE_OK) {
> sqlite3_finalize(statement);
If prepare fails, statement is never updated. So you are passing garbage to
sqlite3_finalize. You sho
Hello! I'm coding a simple method in C++ to insert a tuple in a small
database. The database has a table called 'user', with 3 fields (id -
the primary key, name, and a image).
I mapped these fields in a class - id is an int, name is a std::string
and image is a std::vector of unsigned char. In thi
sqlite> create table questions (answer text);
sqlite> insert into questions values('/FAQ/Doctors');
sqlite> select * from questions;
/FAQ/Doctors
sqlite> select
ltrim(ltrim(ltrim(answer,'/'),'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'),'/')
from questions;
Doctors
You need to add what
i think. problemm from parallel access not i try create mutex in main
project, than sent mutexHandle to my dll and
dw = WaitForSingleObject(hMutex, 5000L) ;
Messagebox(0,L"message",L"box",0); // this messaege(0,L"",L"",0);
if (dw == WAIT_OBJECT_0)
{
CppSQLite3Query q = base.exe
On Thu, Sep 1, 2011 at 9:10 AM, NOCaut wrote:
>
> How wait for finish query?
> while(q1.step()); // or q1.fetch() <<< this function i not find
>
try q1.finalize(), as someone suggested for your previous post.
--
- stephan beal
http://wanderinghorse.net/home/stephan/
__
How wait for finish query?
while(q1.step()); // or q1.fetch() <<< this function i not find
CppSQLite3Query q2= db.execQuery("...");
otherstring = db.execQuery("two"); // out of sequence error
q2.finalize();
--
View this message in context:
http://old.nabble.com/out-of-sequence-error-2-tp32
14 matches
Mail list logo
