Android Question Am I crazy? (SQLite)

[LucaMs]

I have an app that uses SQLite without any problem.

I create a new app for tests and I get the following.

I have a single table and a single INTEGER field.

I insert a single line. I try to read it: RowCount = 0.

So, I try with ExecQueryAsync: same result. In this case, also, a strange thing happens: If I write simply: Log ("Crsr.RowCount =" & Crsr.RowCount) by this time MY cursor no longer has 0 records ... but it contains 0 records!
(clear, right? Take a look at the code)

 

[rboeck]

Hi

i quickly tried to find the problem: first in the database design i found, that the integer size was set to 0; maybe this is possible.
Second thing: i changed the insert routine to the simpler:

Query = "INSERT INTO Test (Age) VALUES (123)"
    Log(Query)
    DB.ExecNonQuery(Query)

and third i had a problem with the cursor position in Readdata, so i added one statement:

Curs.Position=0

the have a cursor position. Maybe only one change of the above is needed, it didnt check each thing alone...

 

[LucaMs]

Thank you for your reply.

The DB and the query does not have problems; in fact, the query works when it is launched in an external tool.

You can not use the cursor position if you get MyCursor.RowCount = 0

 

[LucaMs]

I found the flaw (?).

I have to use ExecuteNonQuery, otherwise the insertion fails.

 

[Mahares]

This will work for you:

Private Sub InsertData
    Private intVar As Int = 123
    Private Query As String   
    Query = "INSERT INTO Test (Age) VALUES (?)"
    Log(Query)   
    DB.ExecNonQuery2(Query, Array As String(intVar))    
    ReadData
End Sub

Private Sub ReadData
    Private intVar As Int
    Private Query As String
    Private Curs As Cursor   
    Query = "SELECT Age FROM Test"
    Curs = DB.ExecQuery(Query)
    Log("Curs.RowCount = " & Curs.RowCount)
    Curs.Position=0  'YOU MUST ADD THIS LINE TOO
    If Curs.RowCount > 0 Then
        intVar = Curs.GetInt("Age")
        Label1.Text = intVar
    Else
       Label1.Text ="Data not found"
    End If
End Sub

 

[LucaMs]

Thanks, Mahares.

My mistake was to use a Query statement to enter data; I must use a NonQuery statement.

(Cursor.Position was my momentary forgetfulness. Given that I obtained Rowcount = 0, I had not noticed it.)