Bug #1167 | MyODBC and Describe Table | ||
---|---|---|---|
Submitted: | 30 Aug 2003 7:10 | Modified: | 16 Oct 2003 22:32 |
Reporter: | Ageu, Jr, Magrini | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | Connector / ODBC | Severity: | S3 (Non-critical) |
Version: | 3.51.06 | OS: | Windows (Windows 98 SE) |
Assigned to: | Bugs System | CPU Architecture: | Any |
[30 Aug 2003 7:10]
Ageu, Jr, Magrini
[6 Oct 2003 0:24]
Venu Anuganti
Hi !! I am not able to reproduce the bavaviour as it simply works fine. Here is the test case and its output performed from 3.51.06 and 3.51.07: Private Sub Describe_Click() Dim Cn As New Connection Dim rs As New Recordset Dim Texto As String Dim N, count, Rows As Integer Cn.ConnectionString = "DSN=myodbc3;OPTION=35" ' try to avoid 35 Cn.Open Cn.Execute "DROP TABLE t_desc" Cn.Execute "CREATE TABLE t_desc(id int, id1 char(2) NOT NULL PRIMARY KEY DEFAULT '10')" rs.Open "Describe t_desc", Cn, adOpenStatic, adLockOptimistic rs.MoveFirst Debug.Print String(15, "-") & "DESCRIBE t_desc " & String(15, "-") For Each fld In rs.Fields Debug.Print fld.Name, Next Debug.Print Debug.Print String(35, "-") Do Until rs.EOF For Each fld In rs.Fields Debug.Print fld.Value, Next rs.MoveNext Debug.Print Loop Debug.Print "Total records: " & rs.RecordCount rs.Close End Sub Output: ---------------DESCRIBE t_desc --------------- Field Type Null Key Default Extra ----------------------------------- id int(11) YES Null id1 char(2) PRI 10
[30 Oct 2003 3:02]
Ageu, Jr, Magrini
I have two Mysql installed. One on Debian and other on Madrake. The Debian one is 3.23.49 There is no newer for debian. The Mandrake is 3.23.56. When I reported the problem I just tested with the debian. I note that the instructions works fine with Madrake one. But The problem is still happen with Debian. I thought bug is in Myodbc, because the instruction works fine in Debian console.