ADO Size Property

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions Material Management  |  Guestbook
 

ADO Parameter object: Size Property

The Size property sets or returns a long value that indicates the maximum size in bytes or characters of a value in a Parameter object.

Syntax

objparameter.Size

Example

set comm=New ADODB.Command
set para=New ADODB.Parameter
para.Type=adVarChar
para.Size=25
para.Direction=adParamInput
para.Value=varfname
comm.Parameters.Append para