System Functions
KEL( ) Return Last Key of File
 
Format KEL(chan[,fileopt])
 
Where:
 
chan Channel or logical file number of the file to reference.
 
fileopt Supported file options (see also, File Options):
  END=stmtref End-of-File transfer
  ERR=stmtref Error transfer
KNO=num | string$ File access key number (num) or name (string$).
 
stmtref Program line number or statement label to which to transfer control.
 
Returns Key of last record in file.
 
Description The KEL( ) function returns the key of the last record in the file specified. The result is based on:
 
• the current file access key or,
 
• the access key specified using the KNO= option.
ProvideX supports the KEL( ) function for ODBC files. For more information, see File
Handling in the ProvideX User's Guide
 
Examples 0010 OPEN (1) "CUSTNO"
......
0100 F$=KEF(1),L$=KEL(1)
0110 PRINT "Customers range from ",F$,"->",L$
......
1010 END