javascript - Do I have to drop the table before creating it in Sqlite? -


When I initialize my SQLite database, I create it as follows: 

  Var db = window .openDatabase ("database", "1.0", "cordova demo", 20000); Db.transaction (populateDB, errorCB, success cc); Function PopularDB (tx) {tx.executeSql ('DROP table, if timetable exists'); Tx.executeSql ('Create table' if 'timetable (ID integer primary key autotrinkement, day, topic, initial time, endingtime) does not exist);}   
 Now, I do not want the table Every time I call this function, drop it. But when I extract this line:  
  tx.executeSql ('DROP TABLE if current timetable' is);   
 shows an error:  
  [INFO] Error in SQL processing: 1   
 is the solution   
 
 
 You can try the solution posted here:

Comments

Post a Comment