I want to insert into a database ..a form's value ..two of them are integer and one is string..but i am not able to view in my sqlite database viewer the value which i am entering.. i am using the following code:
SQLiteDatabase myDB= null;
String TableName = "basicdetai";
try{
myDB = this.openOrCreateDatabase("Medical", MODE_PRIVATE, null);
/* Create a Table in the Database. */
myDB.execSQL("CREATE TABLE IF NOT EXISTS "
+ TableName
+ " (order_id INT(4), doc_id INT(4),doc_name VARCHAR );");
/* Insert data to a Table*/
myDB.execSQL("INSERT INTO "
+ TableName
+ "(order_id,doc_id,doc_name)"
+ " VALUES ("+ ordid + ","+ doci + ","+ docnam +");");
// line 10 + " VALUES ("+ a + ","+ b + ","+ docnam +");");
// line 11 +"VALUES (5011,4011,'gupta');");
}
catch(Exception e) {
Log.e("Error", "Error", e);
}
finally {
if (myDB != null)
myDB.close();
}
but when i am using line 11 in above code i can see the record (5011,4011,'gupta')
through
sqlite browser.
I am performing following operation to convert the string value which i am getting from form to integer
try {
ordid = Integer.parseInt(orderid.getText().toString());
doci = Integer.parseInt(docid.getText().toString());
// qn = Integer.parseInt(qty.getText().toString());
} catch(NumberFormatException nfe) {
System.out.println("Could not parse " + nfe);
}
Plz help ..
There are two basic syntax of INSERT INTO statement is as follows: INSERT INTO TABLE_NAME (column1, column2, column3,... columnN)] VALUES (value1, value2, value3,... valueN);
Please try below query...
db.execSQL("insert into your table name (order_id,doc_id,doc_name)" + "values("ordid+","+doci+","
+ "\"" + docnam + "\"" + ") ;");
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With