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

Sylvania Quicktronic QT2x32/120 IS-SC Ballast
$9.99
Sylvania Quicktronic QT2x32/120 IS-SC Ballast picture*NEW / Factory Box* GE Lighting System Powrspt Ballast Assembly P/N# PSFD01M0A1
$375.99
*NEW / Factory Box* GE Lighting System Powrspt Ballast Assembly P/N# PSFD01M0A1 pictureLot of 5 Juno Lighting NEB650C NaviLite Fluorescent Emergency Ballast 750 Lumen
$169.99
Lot of 5 Juno Lighting NEB650C NaviLite Fluorescent Emergency Ballast 750 Lumen  picture(100) One Hundered Piece Lot Amperite 3-16 Ballast Tube Military Grade New NIB
$195.0
(100) One Hundered Piece Lot Amperite 3-16 Ballast Tube Military Grade New NIB pictureSylvania T5/HO Electornic Ballast-Model QTP 2x54T5HO/UNV PSN HT-120/277V 50/60HZ
$24.99
Sylvania T5/HO Electornic Ballast-Model QTP 2x54T5HO/UNV PSN HT-120/277V 50/60HZ picture






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