1414 HEIDENHAIN Technical Manual iTNC 530 HSCI
Module 9256 Write an integer value to a field in a table
Open the table with the file name extension .TAB or .P with Module 9240, and
not in the "buffered" mode.
The field defined by the column name and line number is overwritten.
This module can be used only for an integer. Values with decimal places are
written without the decimal point.
If a line that does not yet exist is transferred, the file is filled with blank spaces
up to the defined line.
Call:
PS D <File handle>
from Module 9240
PS B/W/D/K <Line>
–1: Next vacant line
0 to 65 535
PS B/W/D/K/S<String number, column name>
PS B/W/D/K <Numerical value to be written>
CM 9256
Error code:
Module 9247 Search 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:
Marker Value Meaning
M4203 0 Field was written to
1 Error code in W1022
W1022 See Module 9246
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...
