QML cannot delete content in a Table

[biskero]

Hello,

I am trying to delete the content of a table, basically clearing all the data.

this is my statement:

db.transaction(
            function(tx) {
                tx.executeSql('DELETE FROM DistanceTable');
            }
)

Seems it's been executed since I do not get any error but values are still there.
Is the syntax correct?

The QML app is running on a mobile phone.

thx