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_at_lp.airnews.net>

[Quoted] 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?

[Quoted] The MS doc says:

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

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

[Quoted] Thanks!

David Thom Received on Tue Sep 07 1999 - 21:18:56 CEST