FOR

Previous Next

FOR clauses in the USoft Rule Language serve to identify the table being queried from, or the table being manipulated.

Do not confuse with FOR WHICH.

Syntax

FOR   single-string-object-name-plural   table-alias

where the required and case-insensitive single-string-object-name-plural is the same or similar to the Object Name Plural value for the table as defined in USoft Definer:

If the Object Name Plural value does NOT contain a space, it is equivalent to the Object Name Plural value, whether surrounded by optional double quotes or not;

If the Object Name Plural DOES contain one or more spaces, you must surround single-string-object-name-plural by double quotes.

For example, if you have a table BANK_ACCOUNT with Object Name Plural = Bank Accounts, the single-string-object-name-plural is:

"Bank Accounts"

and the following are legal variants:

"bank accounts"

"BANK ACCOUNTS"

 

 

collapseFOR ... DO NOT ALLOW THAT
collapseFOR ... MAKE SURE THAT