pbFullText - cWebSuggestionForm
Determines whether a full text search is performed to fill suggestion list
Type: Property
Access: Read/Write
Data Type: Boolean
Parameters: None
Syntax
{ WebProperty=Client }
Property Boolean pbFullText
| Access Type | Syntax |
|---|---|
| Read Access: | WebGet pbFullText to BooleanVariable |
| Write Access: | WebSet pbFullText to BooleanVariable/Value |
Description
pbFullText determines how a suggestion list is filled when performing a standard find search (peSuggestionMode is smFind).
When False, the default, the search is a standard incremental search, where a search string of "ac" would find records starting with "ac" such as "Ace Hardware" and "Acme Games".
When True, the search will include sub-strings that occur anywhere within the field where a search of "ac" would find "Jack's Place" as well as "Ace Hardware" and "Acme Games".
Performing a full text search will be slower than a incremental search, because you cannot jump in and out of the finding index. Basically, a record is found and then compared using the Contains operator. Performing this on a very large table might create lagging performance.
If you are using an SQL table with a supporting driver, a full text search will move the search to the server by using the DataDictionary's SQL filtering capability. In such a case, the SQL server will perform a server-side LIKE query. This may dramatically improve performance.
pbFullText is mostly used when peSuggestionMode is smFind, altough it could be set with validation table searches (smValidationTable).
It might be used with custom searches (smCustom). When creating a custom suggestion list, you determine how the suggestion list is assembled within OnFindSuggestions and it does not matter what the pbFullText value is. However, when the suggestions are displayed, pbFullText determines how characters are highlighted within a suggestion list row. When pbFullText is False, the matching characters are displayed starting with the first character. When pbFullText is True, the first matching character sub-string is highlighted in the text. Therefore, when using a custom list, you will want to set pbFullText so that it matches the strategy you use for filling your list in OnFindSuggestions. See peSuggestionMode for more on this.
pbCaseSensitive determines if the search should be case sensitive. This is applied to both modes.
About Web Properties
Each web property maintains two values: The regular property value is set during object creation and should not be changed during the lifetime of that object. To access that value, use the standard property Get and Set syntax.
The web property value is the local value stored at each client. This is synchronized to the client's local value whenever a server call is being processed. To access the web property value, use the WebGet and WebSet syntax above instead of the standard Get and Set syntax.