-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Manoj M wrote:
> I am working with a project that requires a SQLite recovery module.
The best thing to do is not corrupt the database in the first place! Do
not do any of this http://www.sqlite.org/lockingv3.html#how_to_corrupt
In general you cannot
This appears to be the same as
http://www.sqlite.org/cvstrac/tktview?tn=1893
I've attached a comment there.
This is quite a big trap which I only found when loading up the database
with a lot of data. What's the timescale for fixing the bug?
I will have to bypass the AUTOINCREMENT functionality
Hi,
I am working with a project that requires a SQLite recovery module.
I have a corrupted database(see the link below) where if I am issuing
a query like "select * from objects where dbname='information_schema'"
leads to application crash(even sqlite commandline program). As I was
looking for po
If you want something that is Windows based like you describe, why not use Java
to build a Swing GUI? Delphi and Pascal are a little antiquated so if you need
to revise you may have a problem finding a resource. Also consider the platform
independence if that is a concern
Timothy A. Sawyer, CISS
Thanks
So I can't use it... Ok ... But I got some source code of FastReport ( some
ealier version ) from the internet and it is in Dephi/Pascal. I don't know
both of the tools. Can you use the same code to build a dll which can be
used with other windows programing languages? ( So that no one
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kyle Cronin wrote:
> In essence what I'm looking for is a way to defer database writes in a
> process so that they can all be done at once. However, while I'm
> accumulating update queries,
Why not attach a memory database and accumulate your upd
Hi,
I'm currently looking into SQLite for a website written in PHP. While
I don't have any scaling issues yet, I've been looking into how to
optimize SQLite performance, especially with regard to transactions.
In essence what I'm looking for is a way to defer database writes in a
process s
> I'm compiling sqlite using Visual C++ 6 on windows atm and maybe there is a
> problem that only shows up in VC6 and not in gcc. So with that in mind I'm
> building the Mac port of my software (which is built using gcc) and try to
> reproduce the problem there. I guess if everything is perfect
> > And it return SQLITE_OK, however the value in the DB is NULL, or an
> > empty string.
>
> How do you determine this?
I open the sqlite db in Sqlite database browser and the field is empty. All the
other int fields are there and correct.
> I don't see any obvious problems in the code you've
-- Original Message --
To: General Discussion of SQLite Database (sqlite-users@sqlite.org)
From: Eric Minbiole ([EMAIL PROTECTED])
Subject: Re: [sqlite] sqlite3_bind_text problem
Date: 15/11/2008 12:22:53a
> > Then a bind the values to that statement and write it to the DB. That
>
Hello!
В сообщении от Friday 14 November 2008 22:21:45 Shane Harrelson написал(а):
> If you used the supplied configure to generate your makefile, you can
> change the gcov setting in it to:
> USE_GCOV = 0
Thanks!
Best regards, Alexey.
___
sqlite-users
If you used the supplied configure to generate your makefile, you can change
the gcov setting in it to:
USE_GCOV = 0
HTH.
-Shane
On Fri, Nov 14, 2008 at 10:15 AM, Alexey Pechnikov
<[EMAIL PROTECTED]>wrote:
> Hello!
>
> Start console SQLite
>
> $ sqlite3
> SQLite version 3.6.3
> Enter ".help" fo
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Avinash Mittal wrote:
> But is there any other way to do this other than make test like any script.
"make test" is how you run the tests. If you don't like how that is
done then you will have to write your own code that does it the way you
want and y
Hello!
Start console SQLite
$ sqlite3
SQLite version 3.6.3
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .q
profiling:/usr/src/sqlite3:Cannot create directory
profiling:/usr/src/sqlite3/sqlite-3.6.3/.libs/sqlite3.gcda:Skip
What is strings
profiling:/usr/src/sq
Thanks for that pointer to the icu project. Did not know about that!!
thomas
Am Freitag, den 14.11.2008, 15:27 +0200 schrieb Elefterios
Stamatogiannakis:
> Has anybody successfully compiled sqlite with icu for win32?
>
> I haven't managed to find an libicu for mingw. Any tips welcome.
>
> lefte
Hello,
i'm quite new to programmind with databases...
I'll try to explain my Problem on a symplified example:
I have Two Tables with large amount of data:
CREATE TABLE "tabelle1" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"wert" INTEGER
)
CREATE TABLE "tabelle2" (
"id" INTEGER PRIMAR
I am the author of sqlite3Explorer. Sorry I did not answer you previous
post, reason is I did not motice it... :(
I don't think what you want is feasible. the reason is this: the Dll
expects a "dataset" which sqlite3Explorer builds internally, and the
report engine takes it from there (Design, run
Has anybody successfully compiled sqlite with icu for win32?
I haven't managed to find an libicu for mingw. Any tips welcome.
lefteris
D. Richard Hipp wrote:
> On Nov 14, 2008, at 8:08 AM, Martin Engelschalk wrote:
>
>> Hi all,
>>
>> the ICU project is a very powerful tool to handle codepages,
> Then a bind the values to that statement and write it to the DB. That all
> works except for the TEXT field "Name". I'm calling sqlite3_bind_text like
> this:
>
> char *Name = "Something";
> sqlite3_bind_text(Stmt, 3, (const char*)Name, -1, SQLITE_STATIC);
>
> And it return
On Nov 14, 2008, at 8:08 AM, Martin Engelschalk wrote:
> Hi all,
>
> the ICU project is a very powerful tool to handle codepages, and also
> supports regular expressions (using a class named "RegexMatcher", see
> http://icu-project.org/apiref/icu4c/classRegexMatcher.html).
> So, it should be rela
Hi all,
the ICU project is a very powerful tool to handle codepages, and also
supports regular expressions (using a class named "RegexMatcher", see
http://icu-project.org/apiref/icu4c/classRegexMatcher.html).
So, it should be relatively easy to replace the like() - function in
sqlite (see http:
"Thomas Mittelstaedt"
<[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> Just did a search on my database using
> SELECT * FROM ku2008 where "Empfaenger 1" like '%köck%';
>
> and nothing was found. Doing a SELECT * FROM ku2008 where "Empfaenger
> 1" like '%kÖck%'; with the capital umlaut
"Gilles Ganault" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> One more thing: I'd like to only retrieve rows where code.number and
> COUNT(companies.code) don't match
SELECT code.number, COUNT(companies.code)
FROM code JOIN companies ON (code.id=companies.code)
GROUP BY (code.id)
Thomas Mittelstaedt schrieb:
> Hallo,
>
> Just did a search on my database using
> SELECT * FROM ku2008 where "Empfaenger 1" like '%köck%';
>
> and nothing was found. Doing a SELECT * FROM ku2008 where "Empfaenger 1"
> like '%kÖck%'; with the capital umlaut did find the record.
> The data is ut
Hello Thomas,
I have the same problem. There is no readily available function for
converting utf-8 characters outside 7-bit-Ascii from lower to upper, so
sqlite does not use one.
To achieve this, you have to write your own function and/or incorporate
something like ICU into your project. I stil
"Matthew Allen" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> I have a table with the following fields:
>
> {"Id", "INTEGER PRIMARY KEY AUTOINCREMENT"},
> {"ParentId", "INTEGER"},
> {"Name", "TEXT"},
> {"Unread", "INTEGER"},
> {"Open", "INTEGER"},
> {"ItemType", "INTEGER"},
> {"Sort
Hallo,
Just did a search on my database using
SELECT * FROM ku2008 where "Empfaenger 1" like '%köck%';
and nothing was found. Doing a SELECT * FROM ku2008 where "Empfaenger 1"
like '%kÖck%'; with the capital umlaut did find the record.
The data is utf-8! my sqlite version is 3.5.9 on ubuntu har
Hi all
How can I use the mkFrxEngine.DLL supplied along with the Sqlite3Explorer.
The dll is a report designer and viewer. Please help me to use that dll if
any one knows. I asked the same before 10-14 days ago, but didn't get any
reply. If even the author of the same is reading this please help m
Everything you want is on www.sqlite.org. If you cannot handle that you
probably do not have a use for Sqlite.
Satish wrote:
> Hi!
>Can I get some samples to work on sqlite that is how to create a database
> and inserting ... don' t think again I am joking plz help me.it was bit
> confusing
Hi,
First of all thanks for your valuable help.
I have successfully linked and run the test cases by make test.
But is there any other way to do this other than make test like any script.
Regards
Avinash
___
sqlite-users mailing list
sqlite-users@sqlite
Gilles Ganault schrieb:
> Hello
>
> Data that I download from the web seems to be using different code
> pages at times, and Python doesn't like this.
Not sure what this has to do with SQLite...
Basically both Python (2.x, 3.0 finally gets sane) encoding handling and
HTML/HTTP encoding handling
Oops, wrong newsgroup. Please ignore.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello
Data that I download from the web seems to be using different code
pages at times, and Python doesn't like this.
Google returned a way to handle this, but I'm still getting an error:
print output.decode('utf-8')
File "C:\Python25\lib\encodings\utf_8.py", line 16, in decode
On Tue, 11 Nov 2008 07:30:21 -0500, "Igor Tandetnik"
<[EMAIL PROTECTED]> wrote:
>> SELECT code.number,COUNT(companies.code) FROM code,companies WHERE
>> code.id=companies.code
>>
>
>Add "GROUP BY code.id"
One more thing: I'd like to only retrieve rows where code.number and
COUNT(companies
I have a table with the following fields:
{"Id", "INTEGER PRIMARY KEY AUTOINCREMENT"},
{"ParentId","INTEGER"},
{"Name","TEXT"},
{"Unread", "INTEGER"},
{"Open","INTEGER"},
{"Ite
35 matches
Mail list logo