My command is not functioning as expected and I am struggling to identify the issue. The database opens successfully, however, it fails to process the table creation.
var createtable2 = 'CREATE TABLE IF NOT EXISTS offlineCabinDefects (id INTEGER PRIMARY KEY AUTOINCREMENT, Airline TEXT, Tail TEXT, FlightNumber TEXT,ActionDate TEXT,CabinArea TEXT,CabinItem TEXT, UnserviceableFlag TEXT, RowNumber TEXT,SeatNumber TEXT, Description TEXT, Revision TEXT, UserName TEXT, Password TEXT)';
var db = openDatabase('new', '1.0', 'Defect DB', 65536);
db.transaction(function (tx) {
tx.executeSql(createtable2);
});
I have attempted to use a similar code with fewer columns, which worked fine. However, when trying to execute this particular script containing multiple columns, it does not work.