ADO DefinedSize ºÍ ActualSize ÊôÐÔ

¶¨ÒåºÍÓ÷¨

DefinedSize ÊôÐԻ᷵»ØÒ»¸ö long Öµ£¬¸Ãֵָʾһ¸ö×ֶα»¶¨ÒåµÄ³¤¶È£¨×Ö½Ú£©¡£

ActualSize ÊôÐÔÊÇÒ»¸öÖ»¶ÁÊôÐÔ¡£Ëü»á·µ»ØÒ»¸ö long Öµ£¬¸Ãֵָʾij¸ö×ֶεÄÖµµÄʵ¼Ê³¤¶È¡£Èç¹û ADO ÎÞ·¨È·¶¨¸Ã Field ¶ÔÏóµÄÖµµÄ³¤¶È£¬Ôò·µ»Ø adUnknown¡£

ʹÓà DefinedSize ÊôÐÔ¿ÉÈ·¶¨ Field ¶ÔÏóµÄÊý¾ÝÈÝÁ¿£¬¶ø ActualSize Ôò±íÃ÷Æäʵ¼Ê³¤¶È¡£

Óï·¨

objrs.Fields(number).DefinedSize 
objrs.Fields(number).ActualSize

ʵÀý

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

set rs=Server.CreateObject("ADODB.Recordset")
rs.open "Select * from orders", conn

response.write(rs.Fields(0).DefinedSize)
response.write(rs.Fields(0).ActualSize)

rs.Close
conn.close
%>
VUE