Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Java Development


Thank you for visiting the BlackBerry Support Community Forums.

BlackBerry will be closing the BlackBerry Support Community Forums Device Forums on April 1st (Developers, see below)

BlackBerry remains committed to providing excellent customer support to our customers. We are delighted to direct you to the CrackBerry Forums, a well-established and thorough support channel, for continued BlackBerry support. Please visit http://forums.crackberry.com or http://crackberry.com/ask. You can also continue to visit BlackBerry Support or the BlackBerry Knowledge Base for official support options available for your BlackBerry Smartphone.

"When we launched CrackBerry.com 10 years ago, we set out to make it a fun and useful destination where BlackBerry Smartphone owners could share their excitement and learn to unleash the full potential of their BlackBerry. A decade later, the CrackBerry community is as active and passionate as ever and I know our knowledgeable members and volunteers will be excited to welcome and assist more BlackBerry owners with their questions."

- Kevin Michaluk, Founder, CrackBerry.com

Developers, for more information about the BlackBerry Developer Community please review Join the Conversation on the BlackBerry Developer Community Forums found on Inside BlackBerry.


Reply
Contributor
Posts: 14
Registered: ‎11-11-2010
My Device: Not Specified
Accepted Solution

Attach an SQLite database to another

[ Edited ]

Hi,

 

I'm trying to attach one SQLite database to another using SQLite ATTACH DATABASE command.

 

 

Database d1, d2;

URI dbURI1 = URI.create("file:///SDCard/Databases/SQLiteExample/MyTestDatabase1.db");

Statement st;
if (DatabaseFactory.exists(dbURI1)) {
	d1 = DatabaseFactory.open(dbURI1);
} else {
	d1 = DatabaseFactory.create(dbURI1); 
	st = d1.createStatement("CREATE TABLE 'People' ( 'Name' TEXT, 'Age' INTEGER )");

	st.prepare();
	st.execute();
	st.close();
}

URI dbURI2 = URI.create("file:///SDCard/Databases/SQLiteExample/MyTestDatabase2.db");

if (DatabaseFactory.exists(dbURI2)) {
	d2 = DatabaseFactory.open(dbURI2);
} else {
	d2 = DatabaseFactory.create(dbURI2);
	st = d2.createStatement("CREATE TABLE 'People2' ('Name2' TEXT, 'Age2' INTEGER )");
	
	st.prepare();
	st.execute();
	st.close();
	d2.close();
}

st = d1.createStatement("ATTACH DATABASE '/SDCard/Databases/SQLiteExample/MyTestDatabase2.db' as SECOND_TABLE");
st.prepare(); //THROWS AN EXCEPTION "SQL logic error or missing database"
st.execute();
st.close();

 

 

 

I'm getting a Exception "ATTACH DATABASE /SDCard/Databases/SQLiteExample/MyTestDatabase2.db' as SECOND_TABLE: SQLlogic error or missing database"

when it tries to prepare statement for "Attach Database" command.

 

Is it possible to use the ATTACH DATABASE command with BlackBerry SQLite API?

 

Thanks.

BlackBerry Development Advisor
Posts: 15,885
Registered: ‎07-09-2008
My Device: BlackBerry PRIV
My Carrier: Bell

Re: Attach an SQLite database to another

The ATTACH DATABASE command is not supported by the implementation of SQLite on BlackBerry Smartphones.

Mark Sohm
BlackBerry Development Advisor

Please refrain from posting new questions in solved threads.
Problem solved? Click the Accept As Solution button.
Highlighted
Developer
Posts: 201
Registered: ‎12-17-2010
My Device: Not Specified

Re: Attach an SQLite database to another

Can you please give its aternate Option that I use to create/copy table from other database...

 

Thanks,

Milan