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