I've been encountering an issue while trying to run multiple queries from an imported SQL file in my Javascript code. The individual queries work fine when executed one at a time, but when attempting to run all the queries contained in the "Chinook_Sqlite.sql" file altogether, nothing seems to happen.
If you have any suggestions on how to resolve this issue, I would greatly appreciate it. Thank You..
// Initialize sqlite database
var sqlitedb = openDatabase("Chinook", "", "Chinook", '');
// Import the sql file
$.get("../Chinook_Sqlite.sql", function(content) {
// Begin Transaction
sqlitedb.transaction(function (tx) {
// Execute Queries
tx.executeSql(content);
});
});