STAR Keyword Usage

[jsingh71]

Hi All,

Can anyone explain the STAR kewword usage with example. I searched in Help as well as in reference manual but didn't find the appropriate description.

Thanks in Advance.

[#2]

Hi,

The string used for representing the set of all the values of a field in the database can be set through the star statement. It affects the subsequent Load and Select (SQL) statements. The syntax is:

star is [string ]

where, string is an arbitrary text. Note that the string must be enclosed by Quotation Marks if it contains blanks.

Examples:

Star is *;

Star is %;

Star is;

If nothing is specified, star is; is assumed, i.e. there is no star symbol available unless explicitly specified. This definition is valid until a new star statement is made.

Thanks,

Prabhu

[tresesco]

And,

Note!
Star is an old functionality. It can only be used for section access.

[jsingh71]

Thanks for your reply PRABHU.You copied the reference manual content. If you have any idea about this can you explain its usage with example.

[#5]

it can only be used for section access

[Miguel_Angel_Baeyens]

And even so, its meaning may be confusing.

Take a look at the following example:

STAR IS *;

SECTION ACCESS;

LOAD * INLINE [
ACCESS, USERID, PASSWORD, COUNTRY
ADMIN, ADMIN1, ADMIN1, *
USER, USMANAGER, US1, US
USER, ESMANAGER, ES1, ES
USER, FRMANAGER, FR1, FR
USER, FINANCE, FN1, *
];

SECTION APPLICATION;

When the QVW is open locally, the "*" means all possible values:

• Both Admin1 and Finance user will see all countries
  

But when the very same QVW is open in a server, either by IE Plugin or Ajax client, it means "all listed values":

• Both Admin1 and Finance users will see only COUNTRY = US, ES, FR, even if in the model there are more values for the field Country.

Miguel