Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: finding field infomation with DBI and ODBC

by CubicSpline (Friar)
on Jan 14, 2002 at 18:38 UTC ( [id://138571]=note: print w/replies, xml ) Need Help??


in reply to finding field infomation with DBI and ODBC

You may have already found your answer, but I'm almost certain that the last two values are boolean values which represent, respectively, "Is this column a primary key?" and "Can this column accept NULL values?"

~CubicSpline
"No one tosses a Dwarf!

  • Comment on Re: finding field infomation with DBI and ODBC

Replies are listed 'Best First'.
Re: Re: finding field infomation with DBI and ODBC
by thunders (Priest) on Jan 14, 2002 at 21:14 UTC
    You were half right.
    From the ODBC documentaion:

    DecimalDigits. The number of decimal digits of the column on the data source. If the number of decimal digits cannot be determined or is not applicable, the driver returns 0.

    Nullable. Indicates whether the column allows null values.

    Primary key information would be at least as useful to me as decimal digits. I'm guessing that decimal digits are the second argument to the number(,) datatype? In fact because of this, It doesn't seem like I'm going to be able to fully automate this process.

    After over an hour of looking through ODBC and Access Documentation I still can't figure out exactly what datatypes map to which integers in the second column. It's maddening. I'm still working on a solution to this.

[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://138571]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others scrutinizing the Monastery: (3)
As of 2024-04-25 16:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found