How to get precision of Oracle NUMBER fields from VB6 DAO client?

From: David Thom <davidt_at_npsinc.com>
Date: Tue, 7 Sep 1999 14:18:56 -0500
Message-ID: <F754EC88F1785638.2744269BE02E48A3.D57D98F0D33F3164@lp.airnews.net>

When using DAO/ODBCDirect against Oracle8 from a VB6 client, how can I determine the precision (digits + decimals) of a numeric field at run time?

The MS doc says:

"For fields (other than Memo type fields) that contain character data, the [Field's] Size property indicates the maximum number of characters that the field can hold. For numeric fields, the Size property indicates how many bytes of storage are required."

Any way to map the DAO .SIZE to the precision being used by Oracle for numeric fields? Or, is there an alternate way to get the precision defined to Oracle?

Thanks!

David Thom Received on Tue Sep 07 1999 - 14:18:56 CDT