Well, please allow me to congratulate to the release of 3.2.0 and many
thanks to you guys!
I was wondering whether it might be ALTER TABLE DROP/RENAME COLUMN in next
release?
_
与世界各地的朋友进行交流，免费下载 MSN Messenger:
http://messenger.ms
The following link is dead!
http://www.sqlite.org/sqlite3-3.2.0.bin.gz
sqlite3-3.2.0.bin.gz
(201503 bytes) A statically linked command-line program for accessing and
modifing SQLite databases. See the documentation for additional information.
_
Can the owner of this list please unsubscribe me? I followed the
instructions (such as they are) to unsubscribe but I'm still getting
list mail.
Thank you.
This is just a guess.
SQLite has no implicit transaction like Oracle and some other systems.
So to do the 'commit', you have to first do 'begin'. Otherwise each
SQL command is in it's own little transaction, automatically committed.
Dan.
--- SKORPIO-INFO <[EMAIL PROTECTED]> wrote:
> ah!! opsss
On 21 Mar 2005 at 9:34, Ara.T.Howard wrote:
> this is not always true - on nfs for example. the only atomic ops on nfs are
> mkdir and symlink.
And flock if the filesystem supports it [as ReiserFS does].
/bernie\
--
Bernie Cosell Fantasy Farm Fibers
mailto:[EMAIL PROTECT
sqlite3_open(filename, &db);
where filename is the name of the new file. In theory you should also be
populating it with some SQL tables, but I don't know enough details of
your application to write that code.
Clay
That's very much good enough thank you. Didn't realize that it would
automaticly c
Hi all,
I have a similar setup like the following:
CRETAE TABLE users (id int primary key, name varchar(30));
INSERT INTO users VALUES (1, 'john');
INSERT INTO users VALUES (2, 'frank');
INSERT INTO users VALUES (3, 'david');
CREATE TABLE groups (id int primary key, name varchar(20), user
aleks ponjavic said:
>>From the quick start I've learned how to manipulate a db file but this is
> one created from dos shell.
> Since my program uses databases, when a user creates a new file a new db
> should also be created how can I do this from within the program?
>
sqlite3_open(filename, &d
From the quick start I've learned how to manipulate a db file but this is
one created from dos shell.
Since my program uses databases, when a user creates a new file a new db
should also be created how can I do this from within the program?
___
On Mon, 2005-03-21 at 12:46 -0500, Peter G. Brown wrote:
> Hello,
>
> I have the following:
>
> 1:hello
> 2:goodbye
> 3:howdy in table t1.
>
> I want to, via Tcl/Tk, assign each row to a variable and then display
> each one as a label.
>
> Could anyone provide a code snippet doing the above or
Hello,
I have the following:
1:hello
2:goodbye
3:howdy in table t1.
I want to, via Tcl/Tk, assign each row to a variable and then display
each one as a label.
Could anyone provide a code snippet doing the above or a pointer? I
can't seem to assign the first two rows to labels - I always get the
> yes this is the point. for sure it'd be better to use something else
> here -
> but there are certainly times when it would be nice to do atomic
> updates of
> sqlite dbs. without this ability you are bascially saying that, once
> a system
> goes into production you may never make big changes
On Fri, 18 Mar 2005, Eli Burke wrote:
How about using a second in-memory database for your modifications, then
using ATTACH to merge the changes. I'm fairly sure I remember Dr. Hipp
stating that moving complete rows between attached database tables is very
speedy. Depending on the particulars of yo
On Fri, 18 Mar 2005, Andrew Piskorski wrote:
If besides that one slow update you had ONLY READS (and those reads do not
care which version of the data they get, old or new), I'd say sure, fine, an
atomic "swap in a totally new db" operation might be worth trying.
But for a database with active read
On Fri, 18 Mar 2005, Lothar [unknown-8bit] Märkle wrote:
sqlite3_exec(db, "BEGIN EXCLUSIVE TRANSACTION", NULL, NULL, error);
copyFiles();
sqlite3_exec(db, "COMMIT", NULL, NULL, error);
i think you have to use sqlite3_close to be shure all
data is written. then copy.
Also are you sure it is complete
ah!! opsss . this is the query
# Esecuzione delle modifiche selezionate
def ExecuteMixChange(self, event):
# Effettuo la connessione al database
DATABASE = sqlite.connect('CF_BSS.db')
# Assegnazione del cursore
DB_BSS = DATABASE.cursor()
for x in self.
hi!! sorry fo my english.
UPDATE mission_name SET ability = '0' WHERE id_mission = '1'
why if I make this query me it goes to good aim but it gives back this
error to me?
---
Exception _sqlite.DatabaseError: 'cannot rollback - no t
17 matches
Mail list logo
