KEYED File Indexes

Started by steezware, February 06, 2025, 11:51:10 AM

Previous topic - Next topic

steezware

Overview - which I'm sure everyone already knows...

* One can access a KEYED file by either key or index.
* One can fetch the index for a given record by key value doing...
    rcdIdx = IND(ch, KEY=keyValue$)
  ...and if one knows the index for a record its corresponding key value can be fetched...
    rcdKey$ = KEY(ch, IND=idxValue)

* When a record is updated, the index remains the same for a record, of course.
* If a record is removed and access to it is attempted by index an error 117 is raised.

With all that background, here is my question:

Do indexes get reused?  That is, when a record is deleted will the interpreter assign a previously-used index to a newly created record?