ODXSQL - Commands

UPDATE TEXT

The UPDATE TEXT command generates spelling dictionaries based on words in a database, table or column, to enable misspelling searches.

By default, the UPDATE TEXT command applies to all columns that are indexed with simple, parsed indexes. This can be expanded or limited by using a WITH option (see Options below).

Syntax

UPDATE TEXT FOR <DATABASE databasename | TABLE tablename | COLUMN columnname > [WITH options]

UPDATE TEXT FOR
Required

DATABASE database | TABLE table | COLUMN column
Required. The DATABASE, TABLE, or COLUMN keyword is required followed by the database, table or column name as defined in the Omnidex environment file.

WITH options
Optional. A comma separated list of options to apply to this command.

Options

ALL_MDK - Update the spelling dictionaries for all MDK indexed columns.

PARSED_ONLY - Update the spelling dictionaries only for parsed MDK indexed (;KW) columns.

PROXIMITY_ONLY - Update the spelling dictionaries only for columns indexed with the ;PX (proximity) option.

Example

> update text for database orders
Updated text for CUSTOMERS
Updated text for PRODUCTS
Updated text for ACTIVITY
Updated text for CUST_NOTES
Updated text for ORDERS
Updated text for INVENTORY
Text metadata updated for database ORDERS

>

Top