Find actual field size of numeric field
I need to find actual field size of numeric field
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.
Re: Find actual field size of numeric field
"bservello" <firstname.lastname@example.org> wrote:
>I need to find actual field size of numeric field
>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
>don't know how to get it.
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:
Let me know if I'm wrong, we can talk about it
Have fun :-)
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL