Linker IT Software
Order Home
menubar-top-links menubar-top-rechts

SQL*XL: Database to Excel bridge

Related LIT software: litLIB: Excel power functions pack encOffice: Protect your Excel file easy and safe

Home Products SQL*XL Help VBA SQLXL Database Parameters Parameter

Buy now

Download now

SQL*XL online help

 

SQL*XL API: Parameters Object

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
  

SQL*XL ribbon in Excel