 | | | Show columns from table like 'field ' and odbc 3.51.12 | Show columns from table like 'field ' and odbc 3.51.12 2006-04-21 - By RAPPAZ Francois
Back
Hello list
I would like to get the enum or set members from a field in ms access, and
connect to mysql using ADO. The recordset is made without problem but the Type
field is truncated in the recordset. Is there a work around ?
I tried to loop in the recordset, but it's no use.
here is my code:
Dim Cnt As New ADODB.Connection
Dim Rec As New ADODB.Recordset
Cnt.Open _
"DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=www.unifr.ch;" & _
"DATABASE=...;" & _
"USER=...;" & _
"PASSWORD=...;"
SQL = "SHOW COLUMNS FROM `jrn` LIKE 'dom'"
Rec.CursorLocation = adUseClient
Rec.Open SQL, Cnt, adOpenKeyset, adLockOptimistic
Rec.MoveFirst
Do While Not Rec.EOF
Debug.Print Rec!Type
Rec.MoveNext
Loop
Thanks for any help !
Fran?ois Rappaz
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)
|
|
|