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 Commands

Buy now

Download now

SQL*XL online help
 

SQL*XL: Define command

Define command

SQL*XL
home

Syntax:
Version 1: def[ine] variable=text;
Version 2: def[ine]variable;
Version 3: def[ine];

Description:
Version 1:
Defines a substitution variable. If the variable does not exist it will be created. If there is already a variable with that name, the value will be set.

Version 2:
Displays the definition (value and data type) of the substitution variable in a message box.

Version 3:
Shows the parameters dialog. You can configure variables in the parameters dialog.

Examples:
define employee = Jones;
define my_variable= 'Hello World';
define a=1;
define my_variable;

< P> define;

See also:

SQL*XL ribbon in Excel