Virgilio Alexandre Fornazin pisze:
> Sure. I just tell to do this test to check if the bug is related to this
> component, since it debuted on Vista.
>
Silly thought,but could it be related to database file extension ? I
mean , is it possible that OS is caching some files depending on
Gunnar Roth wrote:
Olaf Beckman Lapré schrieb:
Hi,
Is there a way to do this programmatically? I would like to recover
from a
damaged database upon program startup.
1. Copy the code for dump command from shell.c
2. Try if "vacuum;" command repairs the database. with "pragma
Christian Smith wrote:
Bogus�aw Brandys uttered:
[EMAIL PROTECTED] wrote:
Mikey C <[EMAIL PROTECTED]> wrote:
Please implement table and row level locking. :-)
People commonly believe that doing so must be easy. I
certainly get a lot of requests for it from people who
think they know how.
[EMAIL PROTECTED] wrote:
Mikey C <[EMAIL PROTECTED]> wrote:
Please implement table and row level locking. :-)
People commonly believe that doing so must be easy. I
certainly get a lot of requests for it from people who
think they know how. But in fact, row-level locking
is extraordinarily
[EMAIL PROTECTED] wrote:
Dave Dyer <[EMAIL PROTECTED]> wrote:
The real problem is that sqlite assumes it "owns" the temporary
transaction file that it created, and can do anything it wants with it;
for example read, rename, or delete it.
I think this is a very reasonable assumption.
Any
A. Pagaltzis wrote:
* Roger Binns <[EMAIL PROTECTED]> [2006-06-05 00:05]:
I don't know if anyone has tracked how well Spotlight (Mac) or
Beagle (Linux) work with SQLite files.
They cause no problems. The semantics of the filesystem API on
*nix systems differ from those of Windows; in short, a
Mats Gefvert wrote:
Usually Windows XP/SP2.
The file name of the database is usually "vision8020" with no
extension.
That couldn't be a problem, could it?
Shut down system restore
Pardon?
/ Mats
System restore feature of Windows XP.
I'm guessing now...
Regards
Boguslaw
Mats Gefvert wrote:
What system you are using ?
If this is Windows XP or 2003, then what is the name of this sqlite
database ?
Usually Windows XP/SP2.
The file name of the database is usually "vision8020" with no extension.
That couldn't be a problem, could it?
/ Mats
Shut down system
Daniel Franke wrote:
Hi all.
I spent the last days bragging that a single database file as provided by
sqlite is a far better approach to store data than -literally- thousands of
flat files. Now, I got a small amount of testing data an wow ... I'm stuck.
Area: Bioinformatics. Imagine a
Bert Verhees wrote:
Carl Jacobs wrote:
All would be fine but look at this :
create table test(
price double,
amount double default 0
);
insert into test(price) values("12,0");
amount now = 0.0
The world seems to have settled on using Arabic numerals 0, 1, 2 ... 9. I
think we should
Bogusław Brandys wrote:
Bogusław Brandys wrote:
Hello,
Maybe someone could explain me how to properly store float/decimal
values into sqlite 3.X database ?
I created test table:
create table test(number double);
insert into test(number) values(11);
Now it looks like:
11.0
so
Bogusław Brandys wrote:
Hello,
Maybe someone could explain me how to properly store float/decimal
values into sqlite 3.X database ?
I created test table:
create table test(number double);
insert into test(number) values(11);
Now it looks like:
11.0
so, '.' seems to be always decimal
Hello,
Maybe someone could explain me how to properly store float/decimal
values into sqlite 3.X database ?
I created test table:
create table test(number double);
insert into test(number) values(11);
Now it looks like:
11.0
so, '.' seems to be always decimal separator.
But under my
Geoff Simonds wrote:
Thanks to everyone for all the help on this problem. I am going to try
creating a new thread to touch the tables at startup.
Chris Schirlinger wrote:
We have the same issue, to get around it we fire a thread when the
program starts, intelligently "touching" every table
Igor Tandetnik wrote:
"Vishal Kashyap" wrote
Is their any way we can write simple stored procedures or functions
in sqlite. If yes please do guide me I need this functionality in one
of my open source project.
Not in the usual sense, meaning some language that gets stored in the
database
Eric Scouten wrote:
Earlier today I posted a question about SQLite compiled into my
application generating a "database disk image is corrupted" on a
particular query, but the command-line application does not (even using
the same database file). I haven't seen that message posted yet, but I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Griggs, Donald wrote:
> -Original Message-
> From: administrator [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 16, 2005 5:01 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] Convert / Import
>
>
> Does anybody know a good/quick way
Patrick Dunnigan wrote:
> I am currently using SQLite to process @ 400 million records (and climbing)
> a day by reading files, importing them into SQLite, and summarizing. The
Wow! How much memory those 400 milion of records is using ?
Do you use Sqlite 2 or 3 version ?
I was told that SQlite
18 matches
Mail list logo