please dont rip this site

CreateParameter Method

Creates a new Parameter object with the specified properties.

Syntax

Set parameter = command.CreateParameter(Name, Type, Direction, Size, Value)

The CreateParameter method syntax has these parts:

Part

Description

parameter

An object variable representing the Parameter object you want to create.

command

An object variable representing the Command object for whose Parameters collection you want to create a new Parameter object.

Name

A String representing the name of the Parameter object.

Type

Optional. A Long value specifying the data type of the Parameter object. See the Type property for valid settings.

Direction

Optional. A Long value specifying the type of Parameter object. See the Direction property for valid settings.

Size

Optional. A Long value specifying the maximum length for the parameter value in characters or bytes.

Value

Optional. A Variant specifying the value for the Parameter object.

Remarks

Use the CreateParameter method to create a new Parameter object with the specified name, type, direction, and value. Any values you pass in the arguments are written to the corresponding Parameter properties.

This method does not automatically append the Parameter object to the Parameters collection of a Command object. This lets you set additional properties whose values ADO will validate when you append the Parameter object to the collection.

If you specify a variable-length data type in the Type argument, you must either pass a Size argument or set the Size property of the Parameter object before appending it to the Parameters collection; otherwise, an error occurs.

Applies To

Command

See Also

Append, Parameter, Parameters


file: /Techref/language/asp/comp/dameth01_9.htm, 3KB, , updated: 1996/11/21 18:01, local time: 2024/12/25 10:00,
TOP NEW HELP FIND: 
52.15.111.109:LOG IN

 ©2024 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?
Please DO link to this page! Digg it! / MAKE!

<A HREF="http://sxlist.com/Techref/language/asp/comp/dameth01_9.htm"> CreateParameter Method (ADO)</A>

After you find an appropriate page, you are invited to your to this massmind site! (posts will be visible only to you before review) Just type a nice message (short messages are blocked as spam) in the box and press the Post button. (HTML welcomed, but not the <A tag: Instead, use the link box to link to another page. A tutorial is available Members can login to post directly, become page editors, and be credited for their posts.


Link? Put it here: 
if you want a response, please enter your email address: 
Attn spammers: All posts are reviewed before being made visible to anyone other than the poster.
Did you find what you needed?

 

Welcome to sxlist.com!


Site supported by
sales, advertizing,
& kind contributors
just like you!

Please don't rip/copy
(here's why

Copies of the site on CD
are available at minimal cost.
 

Welcome to sxlist.com!

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  .