UPDATEINDEX
Update the indexes independently of the data. By default, Omnidex will
update the indexes automatically as the data is updated. However, in some
cases, it may be more efficient to update the indexes separately from
the data.
Syntax
UPDATEINDEX table [(column-list)]
BEFORE VALUES
(before-value-list) ROWID before_rowid
AFTER VALUES
(after-value-list) ROWID after-rowid
[ON [INSTANCE]
instance]] [WITH options]
UPDATEINDEX
Required.
table
Required. The name of the table in which the data has been updated.
column-list
Required. A comma separated list of column names.
BEFORE VALUES (before-value-list)
Required. A comma separated list of values for the changed columns, as
they were prior to the update.
ROWID before-rowid
Required. The rowid of the updated row before the update.
AFTER VALUES (after-value-list)
Required. A comma separated list of values for the changed columns after
the update.
ROWID after-rowid
Required. The rowid of the updated row after the update.
[ON [INSTANCE] instance]
Optional. The instance number on which to perform the update. If omitted,
the update will be performed on the current instance.
[WITH options]
Optional - Specify options to be used for this command.
Options
Example
Top
|