BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
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  
Old 08-31-2011, 08:13 AM   #2
salassi
New Member
 
Join Date: Aug 2011
Model: 8310
PIN: N/A
Carrier: Rogers
Posts: 12
Default Re: Sqlite Showing Error In The Insert Statement

the above insert statement is to:retrive the values from the 3 textboxes
1)empidtext
2)empnametext
3)depttext

and insert into the table in SQLite Employees.....
Offline  
Old 08-31-2011, 09:26 AM   #3
hrbuckley
BlackBerry Extraordinaire
 
Join Date: Jan 2006
Model: LEZ10
OS: 10.0.10
Carrier: Rogers CA
Posts: 1,704
Default Re: Sqlite Showing Error In The Insert Statement

Duplicate post, not enough information, poorly formatted. I'm not going through this excercise again.
__________________
My other Blackberry is a PlayBook.
Offline  
Closed Thread



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads for: Sqlite Showing Error In The Insert Statement
Thread Thread Starter Forum Replies Last Post
Eclipse question re auto insert of import statement for BB packages plevintampabay Developer Forum 2 06-27-2008 11:14 AM


Siemens 6AU14 35-0AA00-0AA1 6AU1435-0AA00-0AA1 SIMOTION DRIVE-BASED CONTROL New  picture

Siemens 6AU14 35-0AA00-0AA1 6AU1435-0AA00-0AA1 SIMOTION DRIVE-BASED CONTROL New

$3988.00



6FC5610-0BA10-0AA1 SIEMENS LCD Screen Display 1PCS picture

6FC5610-0BA10-0AA1 SIEMENS LCD Screen Display 1PCS

$2998.00



6AV6643-0BA01-1AX0 Siemens SMART PLC Module 6AV6643-0BA01-1AX0 New In Box picture

6AV6643-0BA01-1AX0 Siemens SMART PLC Module 6AV6643-0BA01-1AX0 New In Box

$840.75



New In Box Siemens 6SL3130-6AE21-0AB1 SINAMICS S120 Module 6SL3 130-6AE21-0AB1 picture

New In Box Siemens 6SL3130-6AE21-0AB1 SINAMICS S120 Module 6SL3 130-6AE21-0AB1

$950.00



LOT OF 10 SIEMENS Q120DFN 20A DUAL AFCI/GFCI PLUG ON NEUTRAL BREAKER BRAND NEW picture

LOT OF 10 SIEMENS Q120DFN 20A DUAL AFCI/GFCI PLUG ON NEUTRAL BREAKER BRAND NEW

$419.99



LOT OF 10 SIEMENS QA120AFC  20A AFCI BREAKER (with pigtail wire) NEW picture

LOT OF 10 SIEMENS QA120AFC 20A AFCI BREAKER (with pigtail wire) NEW

$398.99







Copyright © 2004-2016 BlackBerryForums.com.
The names RIM © and BlackBerry © are registered Trademarks of BlackBerry Inc.