Equinox Online Help - Language Reference - A to Z
UpdateIndex |
|
|---|---|
| Applies to |       |
| Syntax | UpdateIndex IndexName [, UserLoginNameExpression] |
| Action | [Statement] Updates a query index. |
| Scope | Usable anywhere. |
| Notes | Query indexes hold references to selected records in a table. If you modify a record, Equinox does not automatically update query index references. You must therefore do it manually. This statement updates all the records in a query index, specified by IndexName. If the UserLoginNameExpression is supplied, the index instance for that user is selected, rather than the one for the current user. The system workarea SysError is set to a non-zero value if an error occurs, otherwise zero. Returns SysError = 1 if the user specified is not found. |
| Category | Indexes |
| See Also | BlankIndex, CopyIndex, CurrentIndex, GroupSetIndex, IndexFromName, IndexLastUsed, IsDuplicate, KeyValues, MakeKey, MarkIndex, ModifyIndex, NameFromIndex, SetExecuteIndex, SetIndex, UnmarkIndex |
| Example | This method tests whether the current customer record has a contact name. If not, then the customer is removed from the CustContact query index. If there is a contact name, then the index is updated. if contact = "" thenend ifUnmarkIndex CustContactelse <>blockquote> UpdateIndex CustContact |