Android Application Development Tutorial - 118 - How to Create a Dialog

[genis0794]

Sorry I need help, it's not shown the dialog

I get that error on the LogCat:

Failure 1 (near "TABLEpeopleTable": syntax error) on 0x24e538 when preparing 'CREATE TABLEpeopleTable (_id INTEGER PRIMARY KEY AUTOINCREMENT, persons_name TEXT NOT...

Please Help

[genis0794]

@genis0794 ohh yess finally I found it, I forget to add the space after CREATE TABLE

silly me

By the way, thank you for this tutorials, they're helping me a lot

[Laloloop]

Here's My miskate.

1) Used the DB Name as my table name, so I could not insert info to the table.

2) My Program still showed the dialog saying that it worked which the debugger proved not to with an SQLiteException thrown.

So, you must use throws SQLiteException instead of SQLException, otherwise you might not catch the Table Not Found error. And fix the table name for the data to be properly inserted.

Good tutorials!.

[supersushi269]

Those who are having errors try this, I had a problem in the SQL code

I typed "AUTO INCREMENT" instead of "AUTOINCREMENT" silly me :P

[KentuckyIowa2010]

I get error:

public class SQLiteExample extends Activity implements OnClickListener

The type SQLiteExample must implement the inherited abstract method DialogInterface.OnClickListene­r.onClick(DialogInterface, int)

And also:

sqlUpdate.setOnClickListener(t­his);

sqlView.setOnClickListener(thi­s);

The method setOnClickListener(View.OnClic­kListener) in the type View is not applicable for the arguments (SQLiteExample)

Please help

[KentuckyIowa2010]

It got fixed when I imported the project to another computer. When I imported it back to first computer it worked there also. Eclipse is weird sometimes

[anty1988]

Dialog d = new Dialog(this);

I get an error message saing that Dialog(new View.OnClickListener(){}) is undefined

Why?

[booboo5181]

be carefull with the spaces when editing the create table command!!

[SuperOgggy]

whay its didnt work for me? i did step by step what you did there.....it passed the compilation but it still crashing.....anyone have any idea??

[barcaOmessi]

thanks man for this tutorial ,,

i actually ask if someone knows how can i update an already existing database like the database of the contacts to edit on it's numbers ??

[amey630]

I am getting exception after entry.open() in SQLiteExample.java and didItWorks become a false, please give any solution to remove exception. I have done all stuff same as the tutorial.

[JonTwinSoul1]

@amey630 You could try to debug it yourself and figure it out by searching solutions. You can do this by opening the DDMS perspective in eclipse and look for red text in the LogCat or by setting up tracers using Log.i();

I had the same problem of it not working and found I didn't set up my oncreate method properly.

[MrGrahameThomson]

@JonTwinSoul1 You saved me hours of wasted time. Thanks for the help :-)

[TheADMIRAL911]

2st !

[Sakki54]

Why can't iPhones be coded in Java -.- These tuts almost make me want an Android...

[MrGermanBratwurst]

@Sakki54 Its not the language of the iPhone. Its more that you need an apple computer and pay 99$ per year to send it to the appstore

[Sakki54]

@MrGermanBratwurst What I meant buy this is the only language I know is Java. iPhones can only be written in Objective-C.

[MrGermanBratwurst]

@Sakki54 Yes but Objective-C is quite easy to understand if you have some knowledge in Java :)

[mangopearandapples]

@Sakki54 Let's just say that Apple is selfish.

[BardusNub]

1nd!