PI1X Basic Programming Manual Ver. 1.10
86/156
record %
Read record position.
field %
Read field position.
Purpose
:
To revise the data of appoint field in appointed field record.
Syntax
:
DBMS_UPDATE_DATA(DBMSID%, record%, field%, key$)
Example
:
DBMS_UPDATE_DATA(1, 3, 3, "SONG")
Description
:
Several key arguments as below:
DBMSID%
DBMS ID (1~10)
record %
Read record position.
field %
Read field position.
key$
Update string data wanted.
Purpose
:
To search the designated field.
Syntax
:
A%=DBMS_SEARCH_FIELD(DBMSID% , field% , record% ,
key$, flag%)
Example
:
A% = DBMS_SEARCH_FIELD(1, 2, 3, " TEST3", 1)
PRINT A%
Description
:
A%
is an integer variable to be assigned to the result.
A%
Meaning
0
Search defeat.
Other value Match the record position of data
Several key arguments as below:
DBMSID%
DBMS ID (1~10)
field%
Search wanted field.
record%
Search wanted record.
key $
Match wanted string data.
flag%
Search from forward or backward.
1 => Search from forward to backward
2 => Search from backward to forward