Searching "LONGS"

If anyone knows how to search long fields directly using Forms functionality, I'd love to see the answers too! Here's the best I know of.

I know two ways to "search" long fields, neither of which involve just using SQL*Forms. The question was not specific about how you want to do matches, so I include both methods to let the reader judge which you'd prefer.

Long fields can be indexed using SQL*Textretrieval (STR). You can then either use STR to search the long fields or query the STR tables from Forms. STR does pretty well at standard word searching but does have some limitations.

The other way is to use a user exit and write your own search routine loading the long field into a variable and use the string manipulation of the language to perform your search. Some languages are obviously better for this than others.

Jan Received on Thu Mar 16 1995 - 18:35:42 CST