View Single Post
Old 08-31-2011, 08:11 AM   #1
salassi
New Member
 
Join Date: Aug 2011
Model: 8310
PIN: N/A
Carrier: Rogers
Posts: 12
Question Sqlite Showing Error In The Insert Statement

Please Login to Remove!

try
{
URI myURI=URI.create("/SDCard/Databases/"+ "FirstDataBase.db");
d=DatabaseFactory.open(myURI);


Statement st=d.createStatement("INSERT INTO Employees VALUES("'"empidtext.getText()"','"empnametext.getT ext()"','"depttext.getText()"'");


st.prepare();
st.execute();
st.close();
d.close();
}
catch(Exception e)
{
System.out.println(e.getMessage());
e.printStackTrace();
}
Offline   Reply With Quote