Progress
Database Design
Guide
Word Indexing and Non-Progress Databases
Word indexing is a Progress database feature that is not supported by other databases; however, you can simulate it using this method. To create a word index on text from a non-Progress database, you must write a Progress 4GL routine to read records from the non-Progress database and copy the text into a table in a Progress database.
You might define a table with the fields foreign primary key and foreign text. Define a word index on foreign_text and load text and keys from the non-Progress database into the table. You can then use the word index to find the primary keys for records that contain specific words.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |