I think the usual way is to put the SQLite DB file in "raw", on the
phone create an empty DB and close it, then copy the "raw" copy over
this created version. I've never done it myself, though.
On Oct 29, 9:36 am, Mad Troll <trollheim.independ...@googlemail.com>
wrote:
> so how i can do it?
> i remember in one of examples i saw file with line structure:
> data 1 | data2 | data 3
> and application was created db from this file on phone
> so you suggest i should convert my db into text file, and try open
> text file im my app
> to placed content of this file into db created by phone
>
> but i cant create regular sql db and try to add it into project?
>
> bugger
>
> On 29 Oct, 13:35, DanH <danhi...@ieee.org> wrote:
>
> > Oddly, you can't "pre-load" a database. You have to create it on the
> > phone and load it up from a flat file or some other source.
>
> > On Oct 29, 6:13 am, Mad Troll <trollheim.independ...@googlemail.com>
> > wrote:
>
> > > I created database in sql lite with commands:
> > > sqlite.exe
> > > CREATE TABLE "android_metadata" ("locale" TEXT DEFAULT 'en_US');
> > > INSERT INTO "android_metadata" VALUES ('en_US');
> > > CREATE TABLE "myTable" ("ID" int);
> > > INSERT INTO "myTable" VALUES ('1');
> > > .....................
> > > etc.
> > > i saved to file myDatabase.db
> > > and i'm trying open it through android.
> > > I open new project in eclipse
> > > i put my database in assets folder
> > > and i tried open my db using code:
>
> > > SQLiteDatabase checkDB = null;
> > > String DB_PATH = "/data/data/my.andoid.app/databases/";
> > > String DB_PATH = "myDatabase.db";
>
> > > try{
> > > String myPath =DB_PATH + DB_NAME;
> > > checkDB = SQLiteDatabase.openDatabase(myPath, null,
> > > SQLiteDatabase.OPEN_READONLY);
>
> > > }catch(SQLiteException e){
> > > return e.getMessage();
> > > }
>
> > > And i can't open my database.
> > > Could anyone help me and point me what i'm doing wrong?
> > > regards
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
