Skip site navigation (1) Skip section navigation (2)

Re: I cant get the description or default value of a field

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 (view raw or flat)
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


In response to

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-06-13 09:46:17
Subject: Re: Patch for snprintf problem (bug #1000650) 4-th try
Previous:From: serkaneDate: 2006-06-13 08:24:03
Subject: Re: I cant get the description or default value of a field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group