Difference between revisions of "The where Expression"
| Line 1: | Line 1: | ||
| − | + | {{HelpFiles}} | |
| − | {{HelpFiles}} | ||
| − | ==The where Expression== | + | == The where Expression == |
| − | This feature is the most significant difference of CGS considered to other programming languages. It is used with a data table context. | + | This feature is the most significant difference of CGS considered to other programming languages. It is used with a data table context. |
| − | The general form of the where expression is specified below: | + | The general form of the where expression is specified below: |
| − | ''function_exp where [(]condition[)]'' | + | ''function_exp where [(]condition[)]'' |
| − | * ''function_exp'' must be one of the special built-in functions used only with where (see Functions “ Functions Used in where Expressions). The parameters for these functions must be simple expressions using arithmetic operators; they cannot contain any calls to the library functions. | + | *''function_exp'' must be one of the special built-in functions used only with where (see Functions “ Functions Used in where Expressions). The parameters for these functions must be simple expressions using arithmetic operators; they cannot contain any calls to the library functions. |
| − | * ''condition'' is a boolean expression, it can merely contain simple arithmetic, relational and logical operators (see Operators). | + | *''condition'' is a boolean expression, it can merely contain simple arithmetic, relational and logical operators (see Operators). |
| − | Parenthesis enclosing conditions are optional. | + | Parenthesis enclosing conditions are optional. |
| − | For example, in order to get the number of students in class 1, and assign it to a variable named student_num, we use the statement below: | + | For example, in order to get the number of students in class 1, and assign it to a variable named student_num, we use the statement below: |
| − | {| class="tableintopic" style="border-collapse: collapse" | + | {| width="590" class="tableintopic FCK__ShowTableBorders" style="border-collapse: collapse;" bgcolor="#c0c0c0" cellpadding="2" |
|- align="left" valign="top" | |- align="left" valign="top" | ||
| − | | width="590" bgcolor="# | + | | width="590" bgcolor="#c0c0c0" | |
| − | number student_num = count() where (ClassId==1); | + | number student_num = count() where (ClassId==1); |
| − | + | ||
| − | + | |} | |
| + | |||
| + | [[Category:CGScript]] | ||
Revision as of 11:04, 13 April 2012
The where Expression
This feature is the most significant difference of CGS considered to other programming languages. It is used with a data table context.
The general form of the where expression is specified below:
function_exp where [(]condition[)]
- function_exp must be one of the special built-in functions used only with where (see Functions “ Functions Used in where Expressions). The parameters for these functions must be simple expressions using arithmetic operators; they cannot contain any calls to the library functions.
- condition is a boolean expression, it can merely contain simple arithmetic, relational and logical operators (see Operators).
Parenthesis enclosing conditions are optional.
For example, in order to get the number of students in class 1, and assign it to a variable named student_num, we use the statement below:
|
number student_num = count() where (ClassId==1); |
