How do I execute multiple statements in Web SQL?

Question

Is there a way to execute multiple statements in a single transaction? I want to do something like:

db.transaction(function (tx) {
    tx.executeSql(
        "CREATE TABLE Foo(ID INTEGER); CREATE TABLE Bar(ID INTEGER)",
        function (tx, result) {
            alert("success!");
        });
    });

But instead, I'm finding I have to do something like this instead:

db.transaction(function (tx) {
    tx.executeSql("CREATE TABLE Foo(ID INTEGER)");
    tx.executeSql("CREATE TABLE Bar(ID INTEGER)",
        function (tx, result) {
            alert("success!");
        });
    });

Am I limited to having to execute individual statements in their own transaction and then fire off a successFn on the last transaction or is there a way I can execute multiple statements in a single transaction?

Kyaw Tun · Accepted Answer · 2012-12-04 23:13:41Z

7

Your second code is already executing multiple statements in a single transaction. The first code is not correct (not supported) since it is not clear which result to return the callback.

Even if supported, the performance is the same since internally, it will have to converted into second statement.

answered Dec 4, 2012 at 23:13

Kyaw Tun

13.3k15 gold badges59 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I execute multiple statements in Web SQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related