Framework:Syntax of expressions - Revision history

Admin at 06:46, 6 March 2012

2012-03-06T06:46:29Z

← Older revision		Revision as of 07:46, 6 March 2012
Line 101:		Line 101:
	'''Convert'''		'''Convert'''

	{\| ~~cellspacing~~="~~1" cellpadding="5~~" width={{{breite\|60%}}} ~~border="1"~~		{\| class="wikitable" width={{{breite\|60%}}}
	\|-		\|-
	\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''		\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
Line 121:		Line 121:
	'''LEN'''		'''LEN'''

	{\| ~~cellspacing~~="~~1" cellpadding="5~~" width={{{breite\|60%}}} ~~border="1"~~		{\| class="wikitable" width={{{breite\|60%}}}
	\|-		\|-
	\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''		\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
Line 139:		Line 139:
	'''ISNULL'''		'''ISNULL'''

	{\| ~~cellspacing~~="~~1" cellpadding="5~~" width={{{breite\|60%}}} ~~border="1"~~		{\| class="wikitable" width={{{breite\|60%}}}
	\|-		\|-
	\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''		\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
Line 158:		Line 158:
	'''IIF'''		'''IIF'''

	{\| ~~cellspacing~~="~~1" cellpadding="5~~" width={{{breite\|60%}}} ~~border="1"~~		{\| class="wikitable" width={{{breite\|60%}}}
	\|-		\|-
	\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''		\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
Line 178:		Line 178:
	'''TRIM'''		'''TRIM'''

	{\| ~~cellspacing~~="~~1" cellpadding="5~~" width={{{breite\|60%}}} ~~border="1"~~		{\| class="wikitable" width={{{breite\|60%}}}
	\|-		\|-
	\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''		\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
Line 193:		Line 193:
	'''SUBSTRING'''		'''SUBSTRING'''

	{\| ~~cellspacing~~="~~1" cellpadding="5~~" width={{{breite\|60%}}} ~~border="1"~~		{\| class="wikitable" width={{{breite\|60%}}}
	\|-		\|-
	\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''		\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''

Admin at 09:37, 3 May 2010

2010-05-03T09:37:14Z

← Older revision		Revision as of 10:37, 3 May 2010
Line 221:		Line 221:

	[[Category:Framework\|Syntax of expressions]][[Category:Framework Objects\|Syntax of expressions]]		[[Category:Framework\|Syntax of expressions]][[Category:Framework Objects\|Syntax of expressions]]
			[[de:Framework:Syntax_von_Ausdr%C3%BCcken]]

Admin at 09:36, 3 May 2010

2010-05-03T09:36:53Z

← Older revision		Revision as of 10:36, 3 May 2010
Line 1:		Line 1:
	__TOC__		__TOC__
	When creating an expression, the ColumnName property refers to columns. If e. g. the ColumnName of one column is “UnitPrice” and of another column “Quantity”, the following expression results:		When creating an expression, the ColumnName property refers to columns of a [[Framework:Tables\|table]]. If e. g. the ColumnName of one column is “UnitPrice” and of another column “Quantity”, the following expression results:

	"[UnitPrice] * [Quantity]"		"[UnitPrice] * [Quantity]"

Admin at 09:36, 3 May 2010

2010-05-03T09:36:15Z

← Older revision		Revision as of 10:36, 3 May 2010
Line 1:		Line 1:
			__TOC__
	When creating an expression, the ColumnName property refers to columns. If e. g. the ColumnName of one column is “UnitPrice” and of another column “Quantity”, the following expression results:		When creating an expression, the ColumnName property refers to columns. If e. g. the ColumnName of one column is “UnitPrice” and of another column “Quantity”, the following expression results:

Admin at 09:35, 3 May 2010

2010-05-03T09:35:54Z

← Older revision		Revision as of 10:35, 3 May 2010
Line 115:		Line 115:
	\| myDataColumn.Expression="Convert(total,'System.Int32')"		\| myDataColumn.Expression="Convert(total,'System.Int32')"
	\|}		\|}

			All conversions are valid, with the following exceptions: Boolean can only be converted from and into Byte, SByte, Int16, Int32, Int64, UInt16, UInt32, UInt64, String and into itself. Char may be converted from and into Int32, UInt32, String and into itself. DateTime can only be converted from and into String and into itself. TimeSpan can only be converted from and into String and into itself.

			'''LEN'''

			{\| cellspacing="1" cellpadding="5" width={{{breite\|60%}}} border="1"
			\|-
			\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
			\| Requests the length of a character string.
			\|-
			\|style=background-color:#f6f6f6 \| '''Syntax'''
			\| LEN(expression)
			\|-
			\|style=background-color:#f6f6f6 \| '''Arguments'''
			\| expression- the character string to be analysed.
			\|-
			\|style=background-color:#f6f6f6 \| '''Example'''
			\| myDataColumn.Expression="Len(ItemName)"
			\|}


			'''ISNULL'''

			{\| cellspacing="1" cellpadding="5" width={{{breite\|60%}}} border="1"
			\|-
			\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
			\| Examines an expression and returns either the examined expression or a replacement value.
			\|-
			\| style=background-color:#f6f6f6 \|'''Syntax'''
			\| ISNULL(expression, replacementvalue)
			\|-
			\| style=background-color:#f6f6f6 \|'''Arguments'''
			\| expression- the expression to be examined.
			replacementvalue- if the expression is ZERO (Nothing), replacementvalue is returned.
			\|-
			\| style=background-color:#f6f6f6 \|'''Example'''
			\| myDataColumn.Expression="IsNull(price, -1)"
			\|}


			'''IIF'''

			{\| cellspacing="1" cellpadding="5" width={{{breite\|60%}}} border="1"
			\|-
			\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
			\| Requests – according to the result of a logic expression – one of two values.
			\|-
			\| style=background-color:#f6f6f6 \|'''Syntax'''
			\| IIF(expr, truepart, falsepart)
			\|-
			\| style=background-color:#f6f6f6 \|'''Arguments'''
			\| expr- the expression to be analysed.
			truepart- the value which is returned if the expression is True.
			falsepart- the value which is returned if the expression is False.
			\|-
			\| style=background-color:#f6f6f6 \|'''Example'''
			\| myDataColumn.Expression = "IIF(total>1000, 'expensive', 'dear')
			\|}


			'''TRIM'''

			{\| cellspacing="1" cellpadding="5" width={{{breite\|60%}}} border="1"
			\|-
			\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
			\| removes all previous and subsequent spaces, e. g.\r,\n,\t and ' '.
			\|-
			\| style=background-color:#f6f6f6 \|'''Syntax'''
			\| TRIM(expression)
			\|-
			\| style=background-color:#f6f6f6 \|'''Arguments'''
			\| expression- the expression that is to be shortened.
			\|}


			'''SUBSTRING'''

			{\| cellspacing="1" cellpadding="5" width={{{breite\|60%}}} border="1"
			\|-
			\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
			\| Requests a partial character string of a specified length, starting at a specified point in the character string.
			\|-
			\| style=background-color:#f6f6f6 \|'''Syntax'''
			\| SUBSTRING(expression, start, length)
			\|-
			\| style=background-color:#f6f6f6 \|'''Arguments'''
			\|expression- the source character string for the partial character string.
			start- an integer which indicates the start of the partial character string.
			length- an integer which indicates the length of the partial character string.
			\|-
			\| style=background-color:#f6f6f6 \|'''Example'''
			\| myDataColumn.Expression = "SUBSTRING(phone, 7, 8)"
			\|}


			{\| {{Bausteindesign1}}
			\|-
			\| <span style="color: darkblue;">'''Hint'''</span>  You can reset the expression property by assigning a ZERO-value or an empty character string to it. If a standard value is determined for the expression column, all lines already completed are given the default value after the reset of the expression property.
			\|}



			__NOEDITSECTION__

			[[Category:Framework\|Syntax of expressions]][[Category:Framework Objects\|Syntax of expressions]]

Admin at 09:30, 3 May 2010

2010-05-03T09:30:03Z

← Older revision		Revision as of 10:30, 3 May 2010
Line 38:		Line 38:
	'''Total * [Column[\]]'''		'''Total * [Column[\]]'''
	(Only the second bracket must be provided with an escape character.)		(Only the second bracket must be provided with an escape character.)
	User defined values
			===User defined values===

	User defined values can be used in expressions and be compared with column values. Character string values must be put in simple quotation marks. Date values must be put in number characters (#). Decimal values and scientific styles of writing are admissible for numeric values.		User defined values can be used in expressions and be compared with column values. Character string values must be put in simple quotation marks. Date values must be put in number characters (#). Decimal values and scientific styles of writing are admissible for numeric values.
	Example:		Example:
Line 44:		Line 46:
	"Price <= 50.00"		"Price <= 50.00"
	"Birthdate < #1/31/82#"		"Birthdate < #1/31/82#"

	In the case of columns with enumeration values, please change the value into an integer data type. Example:		In the case of columns with enumeration values, please change the value into an integer data type. Example:
	"EnumColumn = 5"		"EnumColumn = 5"
	Operators
	A linkage with the Boolean operators AND, OR and NOT is permissible. By means of brackets you can group clauses and enforce priority. The AND operator has priority over other operators. Example:		===Operators===

			A linkage with the Boolean operators AND, OR and NOT is permissible. By means of brackets you can group clauses and enforce priority. The AND operator has priority over other operators.

			Example:

	(LastName = 'Smith' OR LastName = 'Jones') AND FirstName = 'John'		(LastName = 'Smith' OR LastName = 'Jones') AND FirstName = 'John'

	When creating relational expressions, the following operators are admissible:		When creating relational expressions, the following operators are admissible:
	<,>,<=,>=,<>,=,IN,LIKE
			:<nowiki><</nowiki>
			:<nowiki>></nowiki>
			:<nowiki><=</nowiki>
			:<nowiki>>=</nowiki>
			:<nowiki><></nowiki>
			:<nowiki>=</nowiki>
			:<nowiki>IN</nowiki>
			:<nowiki>LIKE</nowiki>


	The following arithmetic operators are also supported in expressions:		The following arithmetic operators are also supported in expressions:
	+ (Addition),- (~~Subtraction~~),* (~~Multiplication~~),/ (Division),% (Modulo)
	Character String Operators		:<nowiki>+</nowiki> (Addition)
			:<nowiki>-</nowiki> (Subtraktion)
			:<nowiki>*</nowiki> (Multiplikation)
			:<nowiki>/</nowiki> (Division)
			:<nowiki>%</nowiki> (Modulo)


			===Character String Operators===

	Please use the plus sign (+) to link a character string. Whether comparisons of characterstrings are case sensitive or not is determined ty the CaseSensitive property of the DataSet class. You may, however, overwrite this value by means of the CaseSensitive property of the DataTable class.		Please use the plus sign (+) to link a character string. Whether comparisons of characterstrings are case sensitive or not is determined ty the CaseSensitive property of the DataSet class. You may, however, overwrite this value by means of the CaseSensitive property of the DataTable class.
	Wildcard		Wildcard

	Both * and % may be used as wildcards in a LIKE comparison. If the character string in a LIKE clause contains * or %, the characters in brackets ([]) must be included as escape characters. If a bracket is contained in the clause, the parenthesis must be provided with brackets as escape characters (e. g. [[] or []]). A wildcard may be used both at the beginning and at the end of a sample, but may also be used just at the end or just at the beginning of a sample.		Both * and % may be used as wildcards in a LIKE comparison. If the character string in a LIKE clause contains * or %, the characters in brackets ([]) must be included as escape characters. If a bracket is contained in the clause, the parenthesis must be provided with brackets as escape characters (e. g. [[] or []]). A wildcard may be used both at the beginning and at the end of a sample, but may also be used just at the end or just at the beginning of a sample.

	Example:		Example:

	"ItemName LIKE 'product'"		"ItemName LIKE 'product'"
	"ItemName LIKE '*product'"		"ItemName LIKE '*product'"
	"ItemName LIKE 'product*'"		"ItemName LIKE 'product*'"

	Wildcards within a character string are not allowed. 'te*xt' for example is not permissible.		Wildcards within a character string are not allowed. 'te*xt' for example is not permissible.
	Functions
			===Functions===

	The following functions are also supported:		The following functions are also supported:
	Convert
			'''Convert'''

			{\| cellspacing="1" cellpadding="5" width={{{breite\|60%}}} border="1"
			\|-
			\| width="100pt" style=background-color:#f6f6f6 \|'''Description'''
			\| Converts the indicated expression into specified .NET framework type.
			\|-
			\|style=background-color:#f6f6f6 \| '''Syntax'''
			\| Convert(expression, type)
			\|-
			\|style=background-color:#f6f6f6 \| '''Arguments'''
			\| expression- the expression to be converted.
			type- the .NET framework type into which the value is converted.
			\|-
			\| style=background-color:#f6f6f6 \|'''Example'''
			\| myDataColumn.Expression="Convert(total,'System.Int32')"
			\|}

Admin: Created page with 'When creating an expression, the ColumnName property refers to columns. If e. g. the ColumnName of one column is “UnitPrice” and of another column “Quantity”, the followi…'

2010-05-03T09:24:56Z

Created page with 'When creating an expression, the ColumnName property refers to columns. If e. g. the ColumnName of one column is “UnitPrice” and of another column “Quantity”, the followi…'

New page

When creating an expression, the ColumnName property refers to columns. If e. g. the ColumnName of one column is “UnitPrice” and of another column “Quantity”, the following expression results:

"[UnitPrice] * [Quantity]"

When creating an expression for a filter, character strings are included in simple quotation marks:

"LastName = 'Jones'"

The following characters are special characters and must – as described below – be provided with escape characters if they are to be used in the name of a column:

:<nowiki>~</nowiki>
:<nowiki>(</nowiki>
:<nowiki>)</nowiki>
:<nowiki>#</nowiki>
:<nowiki>\</nowiki>
:<nowiki>/</nowiki>
:<nowiki>=</nowiki>
:<nowiki>></nowiki>
:<nowiki><</nowiki>
:<nowiki>+</nowiki>
:<nowiki>-</nowiki>
:<nowiki>*</nowiki>
:<nowiki>%</nowiki>
:<nowiki>&</nowiki>
:<nowiki>|</nowiki>
:<nowiki>^</nowiki>
:<nowiki>'</nowiki>
:<nowiki>"</nowiki>
:<nowiki>[</nowiki>
:<nowiki>]</nowiki>

If the name of a column contains one of the above-referenced characters, the name must be put in brackets. If e. g. you use a column named “Column#” in an expression, write "[Column#]":

'''Total * [Column#]'''

Since brackets are special characters you must use a backslash ("\") as escape character for the bracket if the latter is part of the column’s name. A column named "Column[]" will then be written as follows:

'''Total * [Column[\]]'''
(Only the second bracket must be provided with an escape character.)
User defined values
User defined values can be used in expressions and be compared with column values. Character string values must be put in simple quotation marks. Date values must be put in number characters (#). Decimal values and scientific styles of writing are admissible for numeric values.
Example:
"FirstName = 'John'"
"Price <= 50.00"
"Birthdate < #1/31/82#"
In the case of columns with enumeration values, please change the value into an integer data type. Example:
"EnumColumn = 5"
Operators
A linkage with the Boolean operators AND, OR and NOT is permissible. By means of brackets you can group clauses and enforce priority. The AND operator has priority over other operators. Example:
(LastName = 'Smith' OR LastName = 'Jones') AND FirstName = 'John'
When creating relational expressions, the following operators are admissible:
<,>,<=,>=,<>,=,IN,LIKE
The following arithmetic operators are also supported in expressions:
+ (Addition),- (Subtraction),* (Multiplication),/ (Division),% (Modulo)
Character String Operators
Please use the plus sign (+) to link a character string. Whether comparisons of characterstrings are case sensitive or not is determined ty the CaseSensitive property of the DataSet class. You may, however, overwrite this value by means of the CaseSensitive property of the DataTable class.
Wildcard
Both * and % may be used as wildcards in a LIKE comparison. If the character string in a LIKE clause contains * or %, the characters in brackets ([]) must be included as escape characters. If a bracket is contained in the clause, the parenthesis must be provided with brackets as escape characters (e. g. [[] or []]). A wildcard may be used both at the beginning and at the end of a sample, but may also be used just at the end or just at the beginning of a sample.
Example:
"ItemName LIKE '*product*'"
"ItemName LIKE '*product'"
"ItemName LIKE 'product*'"
Wildcards within a character string are not allowed. 'te*xt' for example is not permissible.
Functions
The following functions are also supported:
Convert