January 2012 8.12 Tables 1613
Module 9247 Search for a condition in a table
In a table opened by Module 9240 in "record-oriented" mode, the function
searches for a data record which fulfills one or more conditions. The conditions
are formulated with a subgroup of the System Query Language (SQL)
database language.
Pay attention to the case of the letters (whether they are small or capital) in
the commands and column names.
If you indicate a starting line, the module can search for several suitable field
entries.
Permissible SQL commands:
Example:
Search a table for the line with the NC program 1.nc and the set datum X=–10.
String contents:
WHERE (PAL/PGM LIKE´PGM´) AND (NAME LIKE´1.nc´) AND (X==–10)
Call:
PS D <File handle>
from Module 9240
PS B/W/D/K <Starting line>
0 to 65 535
PS B/W/D/K/S<String number of condition or string with condition>
0 to 7
CM 9247
PL B/W/D <Line that fulfills the condition>
–1: Error code in NN_GenApiModuleErrorCode (W1022)
Command Meaning
+,–,*,/ Arithmetic operators
NOT, AND, OR Logical operators
<,>, <=, >=, ==, <> Comparisons
LIKE ´abc´ Text comparison
LIKE ´_abc%´ Partial string
() Parentheses
MIN(column name) Minimal value from the column
MAX(column name) Maximum value from the column
To Next Page
Loading...
