Quick References
      ADO
      ASP
      CSS2
      HTML
      JavaScript
      Jet SQL
      VBScript
      WML
      WMLScript
      WSH
      XHTML
      XML DOM
      XSLT

Features
      Knowledge Base
      Tutorials

Partners
     ZVON.ORG
     XML
     Planet Source Code
     VisualBuilder
     Web Design
     Your HTML Source
     XML/XSLT Forums
     ASPAlliance
     Scripts
     
     Programmers Heaven
     Tek-Tips Forums
     Developer Fusion
     Code Project











PROPERTY: Field::ActualSize
long = fieldobject.ActualSize
fieldobject.ActualSize = long
 
The ActualSize property sets or returns a long value that is the actual length of a Field object value. If ADO cannot determine the length, this property will return adUnknown.
 
The companion property, DefinedSize, is used to set the maximum size of a value In other words, DefinedSize defines how long a value can be, while ActualSize telling how long it really is.
 
Code (VBScript):
Set rsData = Server.CreateObject("ADODB.Recordset")
rsData.Open "GuruList", strConnection, , , adCmdTable
rsData.MoveFirst
Do While Not rsData.EOF
   Response.Write "Actual Size = " & rsData(strFieldName).ActualSize & VBCRLF
   Response.Write "Defined Size = " & rsData(strFieldName).DefinedSize & VBCRLF
   rsData.MoveNext
Loop

 


Copyright 1999-2005 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information