Android Question MSSQL

[Mauricio Hamak]

Hello

sql1.OpenConnection("jdbc:jtds:sqlserver://xxx.ddns.net/LaGranja;instance_name=SQLSERVER;user=sa;password=xxx;")
' read columns
Dim res As MSSQLResultSet = sql1.ExecuteQuery("SELECT TOP 30 idProducto, Nombre 'Descripcion', PrecioContado FROM productos where Nombre <> 'MODIFICAR' ORDER BY Nombre")
Do While res.MoveNext
'
lstProductos.AddTwoLines2(res.GetInt(1), res.GetString(2) & " $" & NumberFormat2(res.GetDouble(3), 0, 3, 2, True), res.GetInt(1) & "~" & res.GetString(2) & " $" & NumberFormat2(res.GetDouble(3), 0, 3, 2, True))
Loop

I have these code but olny works in Debug Mode. I use the LIBRARY MSSQL

 

[Erel]

You should use JdbcSQL: https://www.b4x.com/android/forum/threads/84016/#content
See the example.