From: | "serkane" <serkane(at)pcis(dot)com(dot)tr> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: I cant get the description or default value of a field |
Date: | 2006-06-13 08:33:20 |
Message-ID: | 1150187600.655013.149270@u72g2000cwu.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Set Rs = Cn.OpenSchema(adSchemaColumns, Array(Empty, Empty, TableName,
Empty))
Do While Not Rs.EOF
Debug.Print Rs("ORDINAL_POSITION")
Debug.Print Rs("COLUMN_NAME")
Debug.Print Rs("DATA_TYPE")
Debug.Print Rs("COLUMN_DEFAULT")
Debug.Print Rs("IS_NULLABLE")
If IsNull(Rs("CHARACTER_MAXIMUM_LENGTH")) = False Then
Debug.Print Rs("CHARACTER_MAXIMUM_LENGTH")
Debug.Print "0" '** Num_scale=0
Else
Debug.Print Rs("NUMERIC_PRECISION")
Debug.Print Rs("NUMERIC_SCALE")
End If
Debug.Print Rs("DESCRIPTION")
Debug.Print Rs("DISPLAY_SIZE")
Debug.Print Rs("COLUMN_HASDEFAULT"), Rs("COLUMN_DEFAULT")
Rs.MoveNext
Loop
Call RsClose
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2006-06-13 09:46:17 | Re: Patch for snprintf problem (bug #1000650) 4-th try |
Previous Message | serkane | 2006-06-13 08:24:03 | Re: I cant get the description or default value of a field |