Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
And,
Note!
Star is an old functionality. It can only be used for section access.
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.
it can only be used for section access
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:
But when the very same QVW is open in a server, either by IE Plugin or Ajax client, it means "all listed values":
Miguel