Stream Size Property Value Property Command Parameters Collection PROPERTY: Parameter::Size long = parameterobject.Size parameterobject.Size = long   The Size property sets or returns a long value that allows you to define or determine the maximum size in bytes or characters of a value in a Parameter object. Note that this is the maximum, not the actual, size.   If you set a value for a Parameter object to be a variable-length data type, you must specify the Size before appending the object to the Parameters Collection, or an error will be generated. Similarly, if you change the data type of an already appended Parameter object to be a variable-length data type, you must specify the Size before executing the Command object, or an error will be generated.   You can use the Refresh method of the Recordset object to have the provider fill in parameter details. Under these circumstances, the provider will set the variable-length data types to be their maximum size and will allocate the necessary memory. Unfortunately, if memory is at a premium, an error may occur when you attempt an execution. Therefore, you may need to check the Size for provider-assigned variable-length data types.   Code (VBScript): Set objParameter = Server.CreateObject("ADODB.Parameter") objParameter.Type = adInteger objParameter.Size = 3 objParameter.Direction = adParamInput objParameter.Value = intCount objCommand.Parameters.Append objParameter Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information