The where Expression - Revision history

Administrator: /* The where Expression */

2018-12-05T09:01:09Z

The where Expression

← Older revision		Revision as of 09:01, 5 December 2018
Line 9:		Line 9:
	''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 [[DCS evaluateWhereExpression]]). 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).

Line 16:		Line 16:
	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:

	{\| ~~width="590"~~ class="tableintopic FCK__ShowTableBorders" style="border-collapse: collapse;" ~~bgcolor~~="~~#c0c0c0~~" cellpadding="2"		{\| class="tableintopic FCK__ShowTableBorders" style="border-collapse: collapse;" width="590" cellpadding="2" bgcolor="#c0c0c0"
	\|- ~~align~~="~~left~~" ~~valign~~="~~top~~"		\|- valign="top" align="left"
	\| width="590" bgcolor="#c0c0c0" \|		\| width="590" bgcolor="#c0c0c0" \|
	number student_num = count() where (ClassId==1);		number student_num = count() where (ClassId==1);

Cg_pham at 10:04, 13 April 2012

2012-04-13T10:04:56Z

← Older revision		Revision as of 10:04, 13 April 2012
Line 1:		Line 1:
	~~[[Category:CGScript]]~~		{{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~~" cellpadding="2~~" bgcolor="#C0C0C0~~"		{\| 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="#~~C0C0C0~~" \|		\| width="590" bgcolor="#c0c0c0" \|
	number student_num = count() where (ClassId==1);		number student_num = count() where (ClassId==1);
	~~__NOTOC__~~
	~~<!-- imported from file~~: ~~281.htm-->~~		\|}

			[[Category:CGScript]]

Cg_pham at 04:17, 12 December 2011

2011-12-12T04:17:57Z

← Older revision		Revision as of 04:17, 12 December 2011
Line 1:		Line 1:
	[[Category:CGScript]]		[[Category:CGScript]]
			{{HelpFiles}}
	{{~~category tree all\|CGScript\|mode=parents\|hideroot=on\|depth=2}}~~
	~~{{category tree all\|CGScript\|mode=all\|hideroot=off\|depth=1~~}}

	==The where Expression==		==The where Expression==

Cg_pham at 08:17, 6 December 2011

2011-12-06T08:17:45Z

← Older revision		Revision as of 08:17, 6 December 2011
Line 1:		Line 1:
	[[Category:CGScript]]		[[Category:CGScript]]

			{{category tree all\|CGScript\|mode=parents\|hideroot=on\|depth=2}}
			{{category tree all\|CGScript\|mode=all\|hideroot=off\|depth=1}}

	==The where Expression==		==The where Expression==

Cg_pham at 08:33, 21 March 2011

2011-03-21T08:33:35Z

← Older revision		Revision as of 08:33, 21 March 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:CGScript]]

Catglobe: jrfconvert import

2011-03-07T09:09:33Z

jrfconvert import

New page

[[Category:HelpBooks]]

==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:

{| class="tableintopic" style="border-collapse: collapse" width="590" cellpadding="2" bgcolor="#C0C0C0"
|- align="left" valign="top"
| width="590" bgcolor="#C0C0C0" |
number student_num = count() where (ClassId==1);
__NOTOC__