Home > Software design >  near "": syntax error in SQL with android studio
near "": syntax error in SQL with android studio

Time:05-24

I'm working on a SQL databse on java (android studio project) but i have a weird mistake. Basically, everytime i have

near "Hello": syntax error in "INSERT INTO GAMES(_id, PRICE, NAME, DEV, PLATFORM) VALUES (0, 70, Hello, Henri, Terrain)"

I have tried like this

public void addGame(String Price, String Name, String Dev, String Platform) {
    database = getWritableDatabase();
    database.execSQL("INSERT INTO "  SchemeDB.TAB_GAMES  "("
              DBS.COL_GAMES_ID  ", "
              DBS.COL_GAMES_PRICE  ", "
              DBS.COL_GAMES_NAME  ", "
              DBS.COL_GAMES_DEV  ", "
              DBS.COL_GAMES_PLATFORM  ") VALUES ("   i  ", "
              Price  ", "
              Name  ", "
              Dev  ", "
              Platform  ")");
    database.close();

}

My DBS is

public interface SchemeDB {

    int VERSION = 1;
    String DB_NAME = "????";
    String TAB_GAMES = "???";
    String COL_GAMES_ID = "_id";
    String COL_GAMES_PRICE = "PRICE";
    String COL_GAMES_NAME = "NAME";
    String COL_GAMES_DEV = "DEV";
    String COL_GAMES_PLATFORM = "PLATFORM";

}

And i really don't see where is the mistake. Because they're saying "syntax error", but for me, it's look pretty OKAY. Anyone have a clue ? I'm just trying to insert some things in my Database.

CodePudding user response:

Something like this...

      "'"   Name   "', "
      "'"   Dev    "', "
      "'"   Platform   "')");
  • Related