Android Question The app crashed doing an Insert in a sqlite db...

[Luis Felipe]

Hello everybody,

My problem is that my app crashed when I try to do an Insert in a sqlite db.
I've checked every field before inserting them in order to see if one is empty for example or if the length is not correct, etc...
Any help apreciated.
Thank you.

Best regards,

Lou

 

[mc73]

You create a table named 'viajeros', and then you tried inserted data to a table named 'persons'.

 

[Luis Felipe]

You create a table named 'viajeros', and then you tried inserted data to a table named 'persons'.

Thank you so much mc73.
I'm going to modify that right now. It was about to turn me crazy about that.
I don't know where you're living but if you come to the south-east of Spain, you're invited to a spanish beer ;-).
Have a nice day.

 

[DonManfred]

I don't know where you're living but if you come to the south-east of Spain, you're invited to a spanish beer ;-).
Have a nice day.

mc73
Well-Known Member
Male, 41, from Alexandria, Greece

 

[Luis Felipe]

mc73
Well-Known Member
Male, 41, from Alexandria, Greece

Thank you DonManfred, I saw it later . That time I'm the "rookie" guy...
Invited too !

 

[Luis Felipe]

You create a table named 'viajeros', and then you tried inserted data to a table named 'persons'.

I'm doing another Query but that time with the right table "viajeros" but the label LblNumEnc doesn't show any data. What am I missing ?
Thank you.

Sub ContarEncuestas
    Dim Row As Int
    Dim Cursor1 As Cursor
    'Vamos a contar cuantas encuestas no se han enviada
    Cursor1 = SQL1.ExecQuery("SELECT COUNT(*) FROM viajeros WHERE ca_enviado='N'")
    If Cursor1.RowCount > 0 Then                        'si hay encuestas sin enviar
        Row = Cursor1.RowCount                            'set the row count variable
    Else
        Row = 0                                       
    End If
    LblNumEnc.Text = Row
    Cursor1.Close                                        'close the cursor, we don't need it anymore
End Sub

 

[DonManfred]

What am I missing ?

You need to load the layout first before you can use the objects in it.

change

ContarEncuestas
Activity.LoadLayout("MenuPrincipal")

to

Activity.LoadLayout("MenuPrincipal")
ContarEncuestas

 

[Luis Felipe]

You need to load the layout first before you can use the objects in it.

change

ContarEncuestas
Activity.LoadLayout("MenuPrincipal")

to

Activity.LoadLayout("MenuPrincipal")
ContarEncuestas

Changed it but now even the first screen doesn't show :-(. Quite sure my Select is good...
I'm totally stucked!
Thank for your help DonManfred.
(reload the source code because I simplified the worflow of the layouts)

 

[DonManfred]

I got an error when executing the sql to get the count...
Then i changed the packagename to KCSoft.ScrollView.BigPanel and then it works
See this too

 

[Luis Felipe]

I got an error when executing the sql to get the count...
Then i changed the packagename to KCSoft.ScrollView.BigPanel and then it works
See this too

Thank you Don Manfred. Where can I change the packagename ? I don't know how to do it...

 

[DonManfred]

 

[DonManfred]

But, i must be honestly. I don´t know whether the old packagename was the issue or not.
I just had in mind that a packagename should have two dots... So i tried and then it works.
if you change the folder to file.DirRootExternal for example then it works too. But with dirinternal it did not work at the beginning for me here. and i did´nt found the "internal dir" on my (rooted) device. So i thought there must be something wrong and i checked the packagename. Then i tried to use a name with two dots and then it works here.
Kind of magic? I did not expect this result

 

[Luis Felipe]

But, i must be honestly. I don´t know whether the old packagename was the issue or not.
I just had in mind that a packagename should have two dots... So i tried and then it works.
if you change the folder to file.DirRootExternal for example then it works too. But with dirinternal it did not work at the beginning for me here. and i did´nt found the "internal dir" on my (rooted) device. So i thought there must be something wrong and i checked the packagename. Then i tried to use a name with two dots and then it works here.
Kind of magic? I did not expect this result

DonManfred, you're a magician. Now I can see the counter on the screen. But the result ("0") is not what I was expecting...
Thank you.