pbFullText - cDbCJGridColumnSuggestion
Determines whether a full text search is performed to fill suggestion list
Type: Property
Access: Read/Write
Data Type: Boolean
Parameters: None
Syntax
Property Boolean pbFullText
| Access Type | Syntax |
|---|---|
| Read Access: | Get pbFullText to BooleanVariable |
| Write Access: | Set 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, although 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.