Children how to transfer variable value in Sqlite.
Here is the code for creating columns in the code, and my unsuccessful attempt to insert values from text fields.
EditText Name2 = (EditText) findViewById(R.id.editText1); EditText Number2 = (EditText) findViewById(R.id.editText2); Name2.getText().toString(); Number2.getText().toString(); SQLiteDatabase db = openOrCreateDatabase("Rielt",MODE_PRIVATE,null); db.execSQL("CREATE TABLE IF NOT EXISTS ONE("+Name+" VARCHAR,"+Number+" Int);"); db.execSQL("INSERT INTO ONE VALUES('"+ Name2 +",' "+ Number2 +");"); db.close();