[Solved] Creating SQL table in android [closed]

Next line is full of errors

DATABASE_CREATE="CREATE TABLE IF NOT EXISTS"+num+"(date VARCHAR,latitude VARCHAR,longitude VARCHAR);"; // FULL OF ERRORS!!

It should be something like

DATABASE_CREATE="CREATE TABLE IF NOT EXISTS Table" + num + " (date TEXT, latitude TEXT, longitude TEXT)";

So, correct the table creation and delete the
Then, the next line sets the table creation to an EMPTY String

DATABASE_CREATE=""; // EMPTY!! This one is then executed on next line!!

Which is then executed:

db.execSQL(DATABASE_CREATE);

Which is equivalent to

db.execSQL("");

So, correct the table creation string and delete DATABASE_CREATE="";