Find actual field size of numeric field

[bservello]

Hi
I need to find actual field size of numeric field

example

num1 is defined as 15 in length numeric

but when i go get the size


rs.field(i).size comes back with 8 which is max storage, I want the 15 length
don't know how to get it.

B. Servello

[Gonzalo Medina]

"bservello" <bservello@smrtytrek.com> wrote:
>
>Hi
>I need to find actual field size of numeric field
>
>example
>
>num1 is defined as 15 in length numeric
>
>but when i go get the size
>
>
>rs.field(i).size comes back with 8 which is max storage, I want the 15
length
>don't know how to get it.
>
>B. Servello
Let see if I undertood. You executed an SQL Statement is returning a numeric
field and you want to know the length for this value.

'The Connection and recordet has been declare before.
rst.Open "SELECT field1 FROM Table1",cnn

The field1 hold a value of 1970 the lenght is four characters. The following
line of code will return four:
Debug.Print Len(CString(rst("Field1").Value))

Let me know if I'm wrong, we can talk about it

Have fun :-)