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 %>