Android Question problem with JdbcSQL

[kreativa sas]

Hi,
i have a problem with JdbcSQL, i try to explain:
I'm using JdbcSQL to read a mssql database and wverything works fine.
I do a select query in async mode using ExecQueryAsync and it's ok but if I use a query with a left join the app crashes.
The app crashes only in release mode and only the second loop of the nextrow cicle (the first loop is ok but when the app starts to read the second record crashes in release mode (on debug i have no errors)

Somebody can help me?
thanks!!

here is my code:

    Wait For (Connect_) Complete (Success As Boolean)
    If Success Then
    Dim str="select * from k_cicliprod as cp left join k_produzione as p on cp.rowid = p.rowid where p.kid=? and cod_cdl=?"
'    Dim sf As JdbcResultSet = mysql.ExecQuery2(str,Array As Int(cruscotto.idfase,cruscotto.cod_cdl ))
    Dim sf As Object = mysql.ExecQueryAsync("mysql",str, Array As Int(cruscotto.idfase,cruscotto.cod_cdl ) )
    Wait For (sf) mysql_QueryComplete (Success As Boolean, Crsr As JdbcResultSet)
    
    If Success Then
    Dim mypass As String
    Do While Crsr.nextrow
        Dim pp As StringFunctions2
        Label2.text=cruscotto.operatore
        Label4.Text=Crsr.GetString("descr_cdl")
        Label6.Text=Crsr.GetString("numpreventivo")
        Label31.Text=Crsr.GetString("descrizionecliente")
        Label33.Text=Crsr.GetString("prodotto")
        Label35.Text=Crsr.GetString("qta")
        Label11.Text=Crsr.GetString("formato_carta")
        Label12.Text=Crsr.GetString("grammi_carta")
        Label14.Text=Crsr.GetString("tipo_carta")
        Label24.Text=Crsr.GetString("resa_stampa")
        Label18.Text=Crsr.GetString("fto_fustella")
        Label17.Text=Crsr.GetString("descr_fustella")
        Label16.text=Crsr.GetString("resa_fustella")
        Label29.Text=Crsr.GetString("fto_cartone")
        Label28.Text=Crsr.GetString("tipo_cartone")
        datap=Crsr.GetString("datainizioreale")
        dataf=Crsr.GetString("datafinereale")
        idfaseprod=Crsr.GetString("id")
        If datap=Null Then
            Button1.Text="Inizia la lavorazione"
            Label36.Visible=False
            wip=False
        Else
            Button1.Text="chiudi la lavorazione"
            Label36.Visible =True
            wip=True   
        End If
        If dataf=Null Then
            
        Else
            Label36.Visible=False
            Button1.Enabled=False
            Label37.Visible =True
    
            wip=True
        End If
        
        
    Loop

 

[DonManfred]

Your app is the first one which crashes without an Errorstacktrace?
Please post the fulll error.

 

[kreativa sas]

No stack trace simply in release mode the app stops, in debug mode no errors!

 

[josejad]

Try this

JdbcSQL app works in debug but not in release

Hi All, My B4A app uses JdbcSQL to talk to a MySQL database on my local RPI server and performs flawlessly in debug mode but crashes in release mode. Can anyone provide any ideas. Thanks

www.b4x.com

 

[PaulMeuris]

Is the join clause correct: cp.rowid = p.rowid ?
Are you comparing 2 primary keys?

 

[kreativa sas]

Try this

JdbcSQL app works in debug but not in release

Hi All, My B4A app uses JdbcSQL to talk to a MySQL database on my local RPI server and performs flawlessly in debug mode but crashes in release mode. Can anyone provide any ideas. Thanks

www.b4x.com

Hey thanks!! this works for me. problem solved!!