Difference between revisions of "Programmer Guide/General Descriptions/Find Expressions"

From STX Wiki
Jump to navigation Jump to search
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)
 
|}
 
|}
 
  
 
{|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> or <code>></code>
+
|<code>&lt;</code>, <code>&lt;=</code>, <code>==</code>, <code>!=</code>, <code>&gt;=</code> or <code>&gt;&lt;/code>
 
|-
 
|-
|value
+
|<var>value</var>
|a number, or numerical expression or string.
+
|a number or numerical expression, or a string.
 
|}
 
|}
 
  
 
{|style="margin-left:1.5em;"
 
{|style="margin-left:1.5em;"
 
|-
 
|-
|fieldid:cond:mask
+
|<code><var>fieldid</var>:<var>cond</var>:<var>mask</var></code>
 
|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 39:
 
|
 
|
 
|-
 
|-
|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, ignore case
+
|match, ignoring case
 
|-
 
|-
 
|  
 
|  
|!I
+
|<code>!I</code>
|do not match, ignore case
+
|do not match, ignoring case
 
|-
 
|-
 
|  
 
|  
|=R
+
|<code>=R</code>
|match respect case
+
|match, respecting case
 
|-
 
|-
 
|  
 
|  
|!R
+
|<code>!R</code>
|(do not match, respect case)
+
|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
 
|}
 
|}

Revision as of 15:47, 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 ></code>
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