Confirmed. AfterLastRow from the RowSet is True. Collumns Nulled. Even after 3.2 release until today.
Var db As New MySQLCommunityServer
db.Host = "myserver.myhost.com"
db.Port = 3306
db.DatabaseName = "mydb"
db.UserName = "user"
db.Password = "pass"
Var myTable As String = "mytable"
Try
db.Connect
Catch error As DatabaseException
// Connection error
MessageBox(error.Message)
End
Var rs As RowSet = db.TableColumns(myTable)
break
For Each row As DatabaseRow In RS
break
Next
break
Var tableName As String = "Invoices"
var rows As rowset = db.SelectSQL("select column_name from information_schema.columns where table_schema = ? order by table_name,ordinal_position", tableName)
or
Var tableName As String = "Invoices"
var rows As rowset = db.SelectSQL("show columns from " + tableName)