BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-31-2011, 08:11 AM   #1 (permalink)
New Member
 
Join Date: Aug 2011
Model: 8310
PIN: N/A
Carrier: Rogers
Posts: 12
Post Thanks: 0
Thanked 0 Times in 0 Posts
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 (permalink)
New Member
 
Join Date: Aug 2011
Model: 8310
PIN: N/A
Carrier: Rogers
Posts: 12
Post Thanks: 0
Thanked 0 Times in 0 Posts
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 (permalink)
BlackBerry Extraordinaire
 
Join Date: Jan 2006
Model: LEZ10
OS: 10.0.10
Carrier: Rogers CA
Posts: 1,704
Post Thanks: 20
Thanked 77 Times in 68 Posts
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


Thread Tools

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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

BALLUDF BOS-74K-UU-1FR-BO-Z AMPLIFIER NEW
$10.0
BALLUDF BOS-74K-UU-1FR-BO-Z AMPLIFIER NEW  pictureKeyence PS-T1P Amplifier
$4.0
Keyence PS-T1P Amplifier  pictureMRFIC2006R2-MOT-1150 PCS Reel,Microwave Amplifier 900MHZ 2 STAGE PA SOIC-8
$1500.0
MRFIC2006R2-MOT-1150 PCS Reel,Microwave Amplifier 900MHZ 2 STAGE PA SOIC-8 pictureSGS TDA2008 Audio Amplifier 12W IC TO-220 - NOS Qty 3
$20.0
SGS TDA2008 Audio Amplifier 12W IC TO-220 - NOS Qty 3  pictureRohm BA5412 Dual Audio Power Amplifier Integrated Circuit - NOS Qty 1
$9.99
Rohm BA5412 Dual Audio Power Amplifier Integrated Circuit - NOS Qty 1  picture






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