Hi,

I really need help with this.. I have trouble accessing a database.

The application hangs everytime i step into the fetchProfile() method.
Every other way i know produced no results.

I am attaching the 2 classes in a txt file.

Tried everythin i possibly knew, and now i'm saturated..

Just tel me wat mistake am I doin here, will be very greatful to you...

Thanks,
Immanuel

And what's the error the application generates?

instead of:you should do:Well, you _SHOULDN'T_ do this, but as it has the same effect you are probably doing less operations (this means more speed, wooot ).

As far as my eye can see for now, I'd say there are a lot of 'bad' coding practises (well, they aren't really bad, they just cost a lot of overhead). For example: in fetchProfile() you findViewById() all views you need, which costs a lot, while you could/should do this in the onCreate, as the views don't change in you application. So you only should find them once!
2nd, I'm not sure if this is needed, but as you test against result != null, you could also start managing the cursor if it isn't null, because a null cursor never can be closed (maybe this even throws an exception).

But now I see your mistake (well the real probematic one : in DB.fetch() you define String[] columns as {"KEY_NAME", ... wheras this should be {KEY_NAME, KEY_COMPANY, ... because you want the DB constants to be used and not the literals! This will make you fetchProfile throw as you use result.getColumnIndexOrThrow(SwapCardDB.KEY_COMPANY))) which would be working if you were defining the column names correctly. Now I think about it , the result.getColumnIndexOrThrow(SwapCardDB.KEY_COMPANY))) will not generate the exception but the mDb.query() in DB.fetch() will, because you want to fetch columns which don't exist.

I guess that if you had looked in your log, you would have see the exception and found this problem by yourself, as this would have thrown some exceptions a long the line of "column not found" or something like that.

Thanks for the reply,

No error is generated in both the cases.
Sorry if this's a stupid question, but where am i supposed to view the log? There's no error displayed in the console.

I realized the problem with String[] columns, and corrected it. But my problem still doesn't seem to solve.

Here is the flow of my application.

> I insert a new record.

> I try to retrieve it. Not possible. Database helper is null.

> I try to insert another record, and it gets inserted as the first record.

> I try to retrieve it. Again not possible.

Thanks again,
Immanuel

In eclipse use the DDMS view to see the log(cat) or use the commandline tool 'adb logcat'.

I tried my best to try out every possibility again.

I dropped the table. And now it now says no column with "name" exists.

I tired out all possible logic with KEY_NAME and name... No luck..
Attached both classes.

I'm missing out something somewhere.. Just wanna know where.

Thanks,
Immanuel

I replaced the INSERT code posted before this with,




[syntax="java"]

It says no table Profile found

Uffffffffffffffff...............

The control never reaches
[syntax="java"]

You should post your log too, as there probably will be an SQLException or something else.

Here is the log..

It says "No such table: Profile"

Problem solved.. .

I had problems in passing Extras from the root directory..
None of those codes are posted here..

Thanks for the help snowflakes..