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 Functions

Buy now

Download now

SQL*XL online help
 

SQL*XL: SQLBindVariable Excel function

SQLBindVariable 
SQLBindVariableVolatile

SQL*XL
home

Syntax:
=sqlxl.xla!SQLBindVariable(Name)
= sqlxl.xla!SQLBindVariableVolatile(Name)

Name (datatype String): Name of the bind variable

Description:
The SQLBindVariable function displays the value of a bind variable. SQLXLBindVariableVolatile does exactly the same but this function will always be evaluated when Excel calculates.

Examples:
A1: =sqlxl.xla!SQLBindVariable("my_bindvar")

A1: abc
B1: =sqlxl.xla!SQLBindVariable(A1)

See also:

SQL*XL ribbon in Excel