Android Question Java.lang.illegalStateException

Erel said:

Please post the full error message from the logs.

Click to expand...

Rajesh Gupta said:

java.lang.illegalstateException: Couldn't read row 0, col 1 from CursorWindow. Make sure the Cursor is initialized correctly before accessing data from it.

This is the exception which I am getting.

Is the size of the field issue?

Click to expand...

mcqueccu said:

copy the full error code, and also the code which you are using to retrieve the data.

Click to expand...

Try
      
    SQL1.Initialize(File.DirInternal, "Masters.db", True)

    Dim q As String = "SELECT Distinct * FROM tblLedgers WHERE PARTYNAME = '" & ddlaccname.Text & "' AND BDEPID = '" & GlobalConst.BDEPID &"' And CurFY = '" & GlobalConst.CurFY & "'"
    tblLedgers = SQL1.ExecQuery(q)

    If tblLedgers.RowCount > 0 Then
        tblLedgers.Position= 0
      
        Dim JsonFromDb As String = tblLedgers.GetString("PARTYJSON")
        Dim OpeningBal As Double = tblLedgers.GetDouble("OPBAL")
      
        ConvertJSONToDataTableinOFfflineMode(JsonFromDb, OpeningBal,True)
    Else
        Msgbox("No Data Found.", "Access Denied")
        pbaccledger.Visible = False
        ddlaccname.Enabled=True
        txtFrom.Enabled=True
        txtTo.Enabled=True
        btnaccledger.Enabled=True
        imgFrom.Enabled=True
        imgTo.Enabled=True
        End If
    Catch
        Log(LastException)
        Msgbox(LastException, "Exception Occured")
    End Try

Erel said:

This code is wrong and will fail if the user enters a ' in one of the fields.

B4X:

 Dim q As String = "SELECT Distinct * FROM tblLedgers WHERE PARTYNAME = '" & ddlaccname.Text & "' AND BDEPID = '" & GlobalConst.BDEPID &"' And CurFY = '" & GlobalConst.CurFY & "'"
    tblLedgers = SQL1.ExecQuery(q)

Watch the SQL tutorial: https://www.b4x.com/etp.html

Comment the Try / Catch keywords and see the full error message.

Click to expand...

Rajesh Gupta said:

This can be the reason?

Click to expand...

Erel said:

You should post the logs.

Yes. SQL fields are limited to 1mb or 2mb depending on the Android version.

Click to expand...