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

Software categories:
SQL*XL help
First Use
Features
Advanced
Commands
Dialogs
Menu & Toolbar
Excel Functions
Trouble Shooting
VBA & Macros
SQL*XL
Key Features
Usage
Editions
Customers
Forums
Help
Links
Download
Order

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

Copyright (C) 1995-2014 Linker IT Software BV. All Rights Reserved. Oracle is a registered trademark of Oracle corporation. Excel and Office are registered trademarks of Microsoft corporation. Other names appearing on the site may be trademarks of their respective owners. Software, files, documents, articles and other material are provided "as is" and without warranties as to performance or mechantability or any other warranties whether expressed or implied. No warranty of fitness for a particular purpose is offered.
sitemap