The ‘Star’ Regular Statement

This article will cover the syntax of the ‘Star’ regular script statement. 

This statement is used to change the default character used to signify ‘all’. By default, this is the ‘*’ character.

Statement syntax

Copy code 


Star is [string];
StringThis is the character that will be used to signify ‘all’ going forward in ‘load’ and ‘select’ statements.

Example

The ‘all’ character is changed to ‘%’ and all fields are loaded from a QVD file.

Copy code 


Star is %;
ITEM_DETAILS:
LOAD 
	'%'
FROM [lib://Public:DataFiles/ITEM_DETAILS.qvd] (qvd);

Result

All fields in the QVD are loaded into the table ‘ITEM_DETAILS’;