Commands used with keyed files and record buffers

These commands are a subset of General commands, grouped here for convenience.

check	Check that a record buffer contains a record
clearbatch	Clear a batch buffer
close	Close a file, menu, listbox, database or cursor
closefile	Close a file, resetting file position and releasing cached information
delete	Delete a record from a file
find[u]	Find and read a record by full or partial key value
flushall	Flush all sequential and keyed files to disk
insert	Insert a new record into a keyed file
match[u]	Read next record matching current search data
next[u]	Read the next record in a file
nextkey	Read key data only from the next record in a file
nextseq[u]	Read the next record in a file in an undefined order
open	Open a keyed file, menu or listbox
openfile	Open a keyed file
preserve	Preserve a record buffer from global clearing
prev[u]	Read the previous record in a file
prevkey	Read key data only from the previous record in a file
read[u]	Read a record using exact key data
readkey	Read key data only from a record using exact key data
readlock	Lock a file from update by all users
refresh_cache	Client cache service refresh_cache command
rewind	Reposition a file or secondary index at its start
sync_indexes	Synchronise the current file position of all secondary indexes to the current main index file position
testkey	Test for a record with a specified key
unlock	Unlock a record or file
unpreserve	Return a record buffer to global clearing status
wind	Position a file or secondary index at the end
write[kl]	Write a record back to a file
writelock	Lock a file from update by other users

---

RELATED TOPICS

Sequential file commands