[Gambas-user] ODBC Access crash

[KKing]

Hi Brian,
Just curious, what is the basis of your syntax?
I'm not saying one way better than another but I would have expected 
something more along lines of
<<
   Dim $con As New Connection
   Dim intCount As Integer
   Dim rs As Result
   Dim $ExecCmd As String

   Try $con.Close()
   $con.Type = "odbc"
   $con.Host = "CLIENT_INFORMATION_MANAGER"
   $con.Open()

   $ExecCmd = "Select FirstName from ClientList "

   rs = $con.Exec($ExecCmd)

   intCount = rs.Count

   While (rs.Available)
     Print "V_OD_erg:" & rs!FirstName
     rs.MoveNext
   Wend

<<