Positioning a Sculptor keyed file or secondary index at its end

wind

Position a Sculptor keyed file or secondary index at its end


SYNTAX

wind file_id [index = index_id]

Positions the specified file or secondary index at its end, so that a subsequent prev[u] or prevkey command will retrieve the last record in the file, or to the record pointed to by the last key in the index specified. The contents of the file’s record buffer are not affected.

file_id

The file_id must be the identifier assigned to a Sculptor keyed file which has been declared in the program by means of the !ofile declaration, or which has been declared by the !file declaration and subsequently opened.

[index = index_id]

This clause may be used to specify a secondary index to be wound. This must be the name of an index created for the file using the ddeditor program. If the index = clause is present the main file position remains unchanged. If it is absent, the main file is wound.


NOTES

  • The prev[u] and prevkey commands will never return the last record in a file if its key contains the maximum possible value (i.e. all the key fields contain the highest possible value for their key type).


EXAMPLE

wind Address
wind Premises index = TelNumber

RELATED TOPICS

Sculptor keyed files

rewind

prev[u]

prevkey