-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
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
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,
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
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
> 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
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.
___
-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
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
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.
>
>
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
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,
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
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
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
"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
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
"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"},
>
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
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
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
>
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
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
I have a table with the following fields:
{"Id", "INTEGER PRIMARY KEY AUTOINCREMENT"},
{"ParentId","INTEGER"},
{"Name","TEXT"},
{"Unread", "INTEGER"},
{"Open","INTEGER"},
32 matches
Mail list logo
