Dr. Hipp,
Version 3 will implement Locale?
Thanks...
--
Marcos
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hello Dr. Hipp,
I have a question about the following section:
If the SQL COMMIT command turns autocommit on and the autocommit logic
then tries to commit change but fails because some other process is
holding a SHARED lock, then autocommit is turned back off
automatically. This allows the user
The first alpha release of SQLite version 3.0 will occur
in less than 7 days. In preparation for that release, a
document describing the new file locking mechanism has be
prepared and placed on the website.
http://www.sqlite.org/lockingv3.html
Readers who are so inclined are encouraged to read t
> Is there a way I could use LIMIT in an update?
No, but if your table has a single-column primary key,
called PK for example, you can get the same result with
update Address set Retrieved = 1
where PK in (select PK from Address
where Group = 'a' limit 5)
If your primary key c
On Fri, June 11, 2004 12:50, Jay Macaulay said:
> Hi all,
>
> I have a database where I'm selecting rows using LIMIT. Is there a way I
> could use LIMIT in an update? For example right now I do:
>
> SELECT * FROM address WHERE group="a" LIMIT 5;
>
> Is there some way I could instantly update thos
Hi all,
I have a database where I'm selecting rows using LIMIT. Is there a way I could use
LIMIT in an update? For example right now I do:
SELECT * FROM address WHERE group="a" LIMIT 5;
Is there some way I could instantly update those 5 I retrieved? Something like:
UPDATE address SET retr
One reason you can't share a database handle between
threads is that one thread cannot release a file lock
that was obtained by another thread.
Dan.
__
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.ya
Hello Stephen,
On Jun 11, 2004, at 12:18, Drew, Stephen wrote:
The problem with having separate pointers is that the threads
themselves do
not have any idea of the database they will be using, which is wrapped
in
shared classes. The threads are merely worker threads that do arbitrary
jobs.
I don'
Tito,
Thanks again for the reply. I am running on Windows 2000 (5.00.2195) SP4,
and have an Intel P4 2.40GHz with 1.25gb RAM - there is certainly some
contention going on with the file, as I was opening and closing each time.
The problem with having separate pointers is that the threads themselve
9 matches
Mail list logo