Thanks a lot Igor respond my email.
Just want to make sure that I am fully understand about the single database 
connection with multiple database statement handle here.
For example I have one database connection and 2 database statement handle 
using the same connection. Using the first database statement handle I use to 
select the data from database but not yet 
sqlite3_reset nor sqlite3_finalize. The second database statement handle I use 
to delete the data from database and use sqlite3_reset or sqlite3_finalize for 
the second database handle statement.
So "delete" statement of the second database statement handle doesn't commit to 
the database until the first database statement handle sqlite3_reset or 
sqlite3_finalize right.
Once again thank for respond my email
JP



________________________________
From: Igor Tandetnik <itandet...@mvps.org>
To: sqlite-users@sqlite.org
Sent: Wednesday, April 29, 2009 7:48:41 PM
Subject: Re: [sqlite] Transaction control At the SQL Level

"Joanne Pham" <joannekp...@yahoo.com>
wrote in message news:464293.67815...@web90308.mail.mud.yahoo.com
> 1) : If I have mulitple commands which are used the same SQL database
> connection then all commands after the first won't commit to the
> database if the first one is not completed"

Correct.

> 2) Is that sqlite3_reset will be the command to completed the
> statement?

That, or sqlite3_finalize.

> 3) From document above it seems like the "Autocommited" is for each
> SQLite database connection - So if I have serveral commands are using
> the same connection then is there any command that I can use to
> commit each individual command but not wait until the first statement
> finishes.

No.

Igor Tandetnik 



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



      
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to