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

This type of info is stored in USER_TAB_COLUMNS view in dictionary in Oracle. You can do DESCRIBE USER_TAB_COLUMNS (at the Sql*Plus prompt) to see the structure of that view. And then you could come up with a query (or stored proc) that returns all the scale/precision info into your app.

Is there a better way, anybody?

Sergey

In article
<F754EC88F1785638.2744269BE02E48A3.D57D98F0D33F3164_at_lp.airnews.net>,   "David Thom" <davidt_at_npsinc.com> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 07 1999 - 21:07:43 CDT