BEGIN
CREATE TABLE table1 (......);
CREATE TABLE table2 (......);
CREATE TABLE table3 (......);
.
.
.
CREATE TABLE tablex (......);
END;
------------------------------------------------------------------------David Williams Check out our WebOS mobile phone app for the Palm Pre and Pixi:<http://www.dtw-consulting.com/GolfCaddie> Golf Caddie <http://www.dtw-consulting.com/GolfCaddie> | Golf Caddie Forum <http://www.dtw-consulting.com/GolfCaddie/forum> | Golf Caddie FAQ <http://www.dtw-consulting.com/GolfCaddie/faq.html> by DTW-Consulting, Inc.
On 3/15/2011 7:45 PM, DanH wrote:
If you have a bunch of operations to do you should do start/end transaction around them -- much faster. SQL operations are essentially synchronous -- once you do the query and check the return code the operation is done (unless it's returning multiple results). On Mar 15, 6:41 pm, David Williams<dwilli...@dtw-consulting.com> wrote:Do they happen asynchronously? If I want to execute several SQL commands, for example creating a bunch of tables the first time my app is ever launched, then is there a preferred best practice for this? Can it be done with one, long string with each command separated by a semi colon, or have a separate string for each command and call each create table command one after the other? If they are done asynchronously then what is the best way to create table 1, wait for it to finish, check the status and then move onto the second table creation? Hopefully the above is clear. -- ------------------------------------------------------------------------ David Williams Check out our WebOS mobile phone app for the Palm Pre and Pixi: <http://www.dtw-consulting.com/GolfCaddie> Golf Caddie <http://www.dtw-consulting.com/GolfCaddie> | Golf Caddie Forum <http://www.dtw-consulting.com/GolfCaddie/forum> | Golf Caddie FAQ <http://www.dtw-consulting.com/GolfCaddie/faq.html> by DTW-Consulting, Inc.
-- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
<<inline: GClogo.png>>
