Android Question SD_SQL Problem

[thegremlin]

Hy,
maybe you can help me. When I do this query at SQL Studio ill get one result.
When I try to read this at B4A Ill get a error...

"Netto" are a label with : Private Netto As Label

Dim query As String
query = MSSQL.ExecQuery("SELECT fVKNetto FROM dbo.tArtikel WHERE cBarcode='4019111013805' or cArtNr='4019111013805'")
Netto.Text = query
Log(query)

This error I get:

[main=null, nativers=(JtdsResultSet) net.sourceforge.jtds.jdbc.JtdsResultSet@11296b7f, starter=null


also when I try with


[QUOTE]
Dim RS As SD_ResultSet = MSSQL.ExecQuery("SELECT fVKNetto FROM dbo.tArtikel WHERE cBarcode='4019111013805' or cArtNr='4019111013805'")
Netto.Text = RS.GetString2(0)
Log(RS.GetString2(0))
[/QUOTE]



same error...

Thanks

Steven

 

[Xandoca]

Have you tried something like that?

Dim RS As SD_ResultSet = MSSQL.ExecQuery("SELECT fVKNetto FROM dbo.tArtikel WHERE cBarcode='4019111013805' or cArtNr='4019111013805'")
Log(RS.RowCount)
Do While RS .NextRow
    Netto.Text = RS .GetString2(0)
    Log(RS.GetString2(0))
Loop

 

[thegremlin]

Yes, thank you. Now it works.