Parameter Object
SQL*XL
home
SQLXL      
  Database    
    Parameters  
      Parameter

Description:

The parameter object manages a parameter in an SQL statement. It will remain available for the database session. A parameter can either be a subsitution variable or a bind variable. Substitution variables will hwoever always have mode IN and have datatype of varchar (text).

Properties:

Name Data Type Description
DataType Long Returns a number indicating the type of the parameter:
  • litTypeVarchar2
  • litTypeNumber
  • litTypeDate
  • litTypeOther 
Mode Long Returns a number indicating the mode of the parameter:
  • litParamIn: A copy of the parameter is used
  • litParamOut: Output only parameter
  • litParamInOut: Parameter is passed by reference
Value Variant Sets the value of the parameter

 

Methods:

Name Data Type Description
none

 

Example:

Set basic properties of a parameter

  SQLXL.Database.Parameters.SubstVariables("my_parameter").Value = "10"
  SQLXL.Database.Parameters.BindVariables("my_parameter").Mode = litTypeNumber
  SQLXL.Database.Parameters.BindVariables("my_parameter").Mode = litParamIn