Programmer Guide/General Descriptions/Find Expressions: Difference between revisions
From STX Wiki
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
{|style="margin-left:1.5em;" | {|style="margin-left:1.5em;" | ||
|- | |- | ||
|<var>cexpr</var> | |<code><var>cexpr</var></code> | ||
|Description | |Description | ||
|- | |- | ||
|fieldid:cond | |<code><var>fieldid</var>:<var>cond</var></code> | ||
|Check if a value is (not) assigned to a field.{| | |Check if a value is (not) assigned to a field.{| | ||
|- | |- | ||
|fieldid | |<var>fieldid</var> | ||
|name or index of a defined field | |name or index of a defined field | ||
|- | |- | ||
|cond | |<var>cond</var> | ||
|= (is assigned), ! (is not assigned) | |<code>=</code> (is assigned), <code>!</code> (is not assigned) | ||
|} | |} | ||
| Line 18: | Line 18: | ||
{|style="margin-left:1.5em;" | {|style="margin-left:1.5em;" | ||
|- | |- | ||
|fieldid:cond:value | |<code><var>fieldid</var>:<var>cond</var>:<var>value</var></code> | ||
|Check the value of a numerical field (type <code>INTEGER</code> or <code>NUMBER</code>) or find an absolute string match (type STRING for <code>==</code> and <code>!=</code>).{| | |Check the value of a numerical field (type <code>INTEGER</code> or <code>NUMBER</code>) or find an absolute string match (type <code>STRING</code> for <code>==</code> and <code>!=</code>).{| | ||
|- | |- | ||
|fieldid | |<var>fieldid</var> | ||
|name or index of a numerical field (<code>0</code> for simple tables) | |name or index of a numerical field (<code>0</code> for simple tables) | ||
|- | |- | ||
|cond | |<var>cond</var> | ||
|<code> | |<code><</code>, <code><=</code>, <code>==</code>, <code>!=</code>, <code>>=</code> or <code>></code> | ||
|- | |- | ||
|value | |<var>value</var> | ||
|a number | |a number or numerical expression, or a string. | ||
|} | |} | ||
| Line 34: | Line 34: | ||
{|style="margin-left:1.5em;" | {|style="margin-left:1.5em;" | ||
|- | |- | ||
|fieldid:cond:mask | |<var>fieldid</var><code>:</code><var>cond</var><code>:</code><var>mask</var> | ||
|Match the value of a string field (type <code>NAME</code> or <code>STRING</code>).{| | |Match the value of a string field (type <code>NAME</code> or <code>STRING</code>).{| | ||
|- | |- | ||
| Line 41: | Line 41: | ||
| | | | ||
|- | |- | ||
|fieldid | |<var>fieldid</var> | ||
|name or index of a string field (<code>0</code> for simple tables) | |name or index of a string field (<code>0</code> for simple tables) | ||
|- | |- | ||
|cond | |<var>cond</var> | ||
|=I | |<code>=I</code> | ||
|match, | |match, ignoring case | ||
|- | |- | ||
| | | | ||
|!I | |<code>!I</code> | ||
|do not match, | |do not match, ignoring case | ||
|- | |- | ||
| | | | ||
|=R | |<code>=R</code> | ||
|match | |match, respecting case | ||
|- | |- | ||
| | | | ||
|!R | |<code>!R</code> | ||
| | |do not match, respecting case | ||
|- | |- | ||
|mask | |<var>mask</var> | ||
|match string, may contain wildcard characters. if field is of type name, mask must be a valid name | |match string, may contain wildcard characters. if <var>field</var> is of type <code>name</code>, mask must be a valid name | ||
|} | |} | ||
Latest revision as of 15:50, 28 April 2014
cexpr
|
Description |
fieldid:cond
|
|
| fieldid | name or index of a defined field |
| cond | = (is assigned), ! (is not assigned)
|
fieldid:cond:value
|
|
| fieldid | name or index of a numerical field (0 for simple tables)
|
| cond | <, <=, ==, !=, >= or >
|
| value | a number or numerical expression, or a string. |
fieldid:cond:mask
|
||
| fieldid | name or index of a string field (0 for simple tables)
| |
| cond | =I
|
match, ignoring case |
!I
|
do not match, ignoring case | |
=R
|
match, respecting case | |
!R
|
do not match, respecting case | |
| mask | match string, may contain wildcard characters. if field is of type name, mask must be a valid name
|
