Sub printnew_Click
Main.ResultSet1=Main.SQL1.ExecQuery("select * from newcon")
Dim rr1,rr2,rr3,rr4 As String
If Main.ResultSet1.RowCount>0 Then
Printer.Initialize2(BTConnection.OutputStream,"windows-1252") 'important to print f.e. German/French chars
PrintBuffer=Chr(27)&"t"&Chr(16)&"" '"Hello öäüßéèê" 'Set codepage 1252
Printer.WriteLine(Chr(29)&""&Chr(13))
Main.ResultSet1.Position=0
Printer.WriteLine(Chr(29)&"Other Readings:"&Chr(13))
For ii = 0 To Main.resultset1.rowcount-1
Main.resultset1.Position=ii
rr1=Main.resultset1.GetString2(0)
rr2=Main.resultset1.GetString2(1)
rr3=Main.resultset1.GetString2(2)
rr4=Main.resultset1.GetString2(4)
Printer.WriteLine(rr1&" "&rr2&" "&rr3&" "&rr4)
Next
Printer.WriteLine(Chr(27) & "Z1" & Chr(6) & "L" & "123456") 'sample to print in barcode the text 123456 chr(6) means 6 characters
Printer.WriteLine("")
Printer.WriteLine("")
Printer.WriteLine("")
Printer.WriteLine("")
Printer.WriteLine("")
Printer.WriteLine("")
Printer.Flush
End If
End Sub