Dbms commands – Argox PA-20 Basic Programming Manual User Manual
Page 83

PT-Basic Programming Manual Ver. 1.00
82/143
3.15.2
DBMS Commands
Purpose: To initiate the file search in disk.
Syntax: A%=DBMS_INIT_SEARCH(FilePath$ , DBMSID% , S$ ,
N1% ,N2% ,N3%)
Example: Result%=DBMS_INIT_SEARCH("C:\DATA\variable.DAT",1,",",
1,0,3)
Result
%=DBMS_INIT_SEARCH("C:\DATA\fix.DAT",2,"6,8,8",0,22,3)
Description: A% is an integer variable to be assigned to the result.
A%
Meaning
0
DBMS initialization fail
1
DBMS initialization OK
5
Open file error
6
The DBMS ID is illegal.
7
DBMS ID already used.
8
The record type is illegal.
9
The field number exceeds 20.
Several key arguments as below:
FilePath$
DBMS file path
DBMSID
%
DBMS ID (1~10)
S$
This argument has two kinds of meanings.
When search for regular length, it needs to
insert the unsigned char array; the array
represents the length of every field.
When search for variable length, it needs to
insert one character to represent separate
symbol.
N1%
When N1%=0, search for regular length. It
has no separate symbols between different
fields.
When N1%=1, search for variable length. It
needs a separate symbol between different
fields.
N2%
This argument is each record‟s length.
When N1%=0, needs to insert this value,