Yasmin,
Your best bet is to examine the Notepad sample application that is
bundled with the SDK. This shiuld provide a basis for your DB code.
Al.
On Oct 31, 3:32 am, "yasmin afrose" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've executed some simple application in android. Now I want to connect my
> DB with my application.
>
> For eg, table has the fields for language & corresponding language no.
>
> Another table has language no, video no & video path(ie, net path)
>
> Here language no is PRIMARY key in First Table. In 2nd table, Language no
> becomes Foreign key & Video no is primary key.
>
> So, Could you please any one explain? How can I connect my DB with Android
> Application?. (ie, If the user enters language name then it will displays
> the corresponding video files in the form of list.)
> Which DB is best (ie, SQL SERVER \ MY SQL)? What are base
> requirements\knowledge to explore this application?
>
> Can you please send your application source code with detailed explanation?
>
> Thanks in advance.
>
> Thanks Again!!
> Yasmin
> On Fri, Oct 31, 2008 at 4:14 AM, Alistair. <
>
>
>
> [EMAIL PROTECTED]> wrote:
>
> > Okay I fixed it. Not sure if the solution will apply to you.
>
> > In my 'onUpgrade' function the table name value was incorrect.
>
> > Basically it looks like you are not dropping the table you
> > subsequently then attempt to recreate. Check your defns.
>
> > Al.
>
> > On Oct 29, 8:16 pm, Frew <[EMAIL PROTECTED]> wrote:
> > > So I presume that no one else has seen this error?
>
> > > -fREW
>
> > > On Oct 27, 8:30 pm, Frew <[EMAIL PROTECTED]> wrote:
>
> > > > Ok, so everything that I've been doing with my db has been fine until
> > > > I changed it. I made sure that the onUpgrade was right and I get
> > > > errors nonetheless. Here is my method:
>
> > > > @Override
> > > > public void onUpgrade(SQLiteDatabase db, int oldVersion, int
> > > > newVersion) {
> > > > db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
> > > > db.execSQL("DROP TABLE IF EXISTS " + FIRST_RUN_TABLE);
> > > > onCreate(db);
> > > > }
>
> > > > and here is the error:
>
> > > > android.database.sqlite.SQLiteException: Can't upgrade read-only
> > > > database from version 1 to 2
>
> > > > I can't seem to find my error. Can you tell what I am doing wrong
> > > > here?
>
> > > > Thanks!
> > > > -fREW
>
> --
> Everything is Possible For U only
--~--~---------~--~----~------------~-------~--~----~
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
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
