December 2001 Display and Operation 6 – 315
Module 9247 Searching for a condition in a table
Open the table with Module 9240 not in the “buffered” mode.
The module searches for a field content that fulfills one or more conditions.
The conditions are formulated with the commands of the System Query
Language (SQL) data bank 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 in a pallet table for the line with the NC program 1.H and the set datum
X=–10.
String contents:
WHERE (PAL/PGM LIKE´PGM´) AND (NAME LIKE´1.H´) 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 W1022
Command Meaning
+,–,*,/ Arithmetical 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...
