Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 10 of 10 total |
Full Text Indexing parameters |
Sat, Feb 3 2007 10:55 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
I want to be able to have two options - MinWordLength and MaxWordLength which I pass into the TextFilter. How can I achieve this? One thing I'm NOT going to do is set the FilterType column depending on what a user selects for these two options, just in case you were thinking of suggesting that Roy Lambert |
Mon, Feb 5 2007 9:59 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I want to be able to have two options - MinWordLength and MaxWordLength which I pass into the TextFilter. How can I achieve this? >> You don't want to use a text filter for this. What you want to do is create a new word generator instead. See the word generator template in Delphi's repository for how to create one. Remember that you have to make it known to EDB also: http://www.elevatesoft.com/edb1sql_create_word_generator.htm -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Feb 6 2007 5:42 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< I want to be able to have two options - MinWordLength and MaxWordLength >which I pass into the TextFilter. How can I achieve this? >> > >You don't want to use a text filter for this. What you want to do is create >a new word generator instead. See the word generator template in Delphi's >repository for how to create one. Remember that you have to make it known >to EDB also: Same question really then. All I can see is a "Collation" parameter which has to be set when the index is created.. Since these are user defined parameters I need some way to pass them in without having to create every possible variation of MinWordLength and MaxWordLength as a wordgenerator in its own right. Roy Lambert |
Tue, Feb 6 2007 6:30 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Same question really then. All I can see is a "Collation" parameter which has to be set when the index is created.. Since these are user defined parameters I need some way to pass them in without having to create every possible variation of MinWordLength and MaxWordLength as a wordgenerator in its own right. >> So you want to pass in different word generation parameters for each row in the table ? If so, then the answer is that no, you can't do that. And I'm not sure if you would want to do that. Using different word generation parameters for each row could really cause confusion as to why a given row is being included in the results of a query/filter. IMO, it is important to use the same word generation parameters across all rows in order to generate uniform results. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Feb 7 2007 4:10 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< Same question really then. All I can see is a "Collation" parameter which >has to be set when the index is created.. Since these are user defined >parameters I need some way to pass them in without having to create every >possible variation of MinWordLength and MaxWordLength as a wordgenerator in >its own right. >> > >So you want to pass in different word generation parameters for each row in >the table ? Not each row. Just optional on an app by app basis (set once for an app) but if you think of the number of possibilities there are with say MinWordLendth between 2 and 4 and MaxWordLength between 20 and 60 I do not want to write even stub procedures which call the real procedure for that many cases. Plus I can see no way of switching short of altering the column definition to alter the Collation. > Using different word generation >parameters for each row could really cause confusion as to why a given row >is being included in the results of a query/filter. IMO, it is important to >use the same word generation parameters across all rows in order to generate >uniform results. Fully agree with that. Roy Lambert |
Wed, Feb 7 2007 4:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Not each row. Just optional on an app by app basis (set once for an app) but if you think of the number of possibilities there are with say MinWordLendth between 2 and 4 and MaxWordLength between 20 and 60 I do not want to write even stub procedures which call the real procedure for that many cases. Plus I can see no way of switching short of altering the column definition to alter the Collation. >> In that case, just write a different word generation DLL for each application, or write one that can read its parameters from the registry or an .INI file (or an EDB table, for that matter) and use them to affect the word generation. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Feb 8 2007 4:25 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>In that case, just write a different word generation DLL for each >application, or write one that can read its parameters from the registry or >an .INI file (or an EDB table, for that matter) and use them to affect the >word generation. Unless I'm missing something, or misinterpreting the template you're suggesting reading the registry, reading a file or opening a table for EVERY word in the text passed in. Please tell me I'm wrong. Roy Lambert |
Thu, Feb 8 2007 1:20 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Unless I'm missing something, or misinterpreting the template you're suggesting reading the registry, reading a file or opening a table for EVERY word in the text passed in. Please tell me I'm wrong. >> No, I'm saying to load the registry or .INI file settings when the DLL is loaded, which only occurs once. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Feb 8 2007 1:49 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
That's a relief, on the basis is 6 or more years ago that I last did anything with a dll the bulb is only glowing slightly. Roy Lambert |
Fri, Feb 9 2007 3:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< That's a relief, on the basis is 6 or more years ago that I last did anything with a dll the bulb is only glowing slightly. >> The DLLs are the first crack at it because they are the most generic. The ..NET support will have assembly support, of course, but I also intend to add plain Delphi runtime package support so that you can simply implement a class or interface in the runtime package. This should make them much faster also. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, June 12, 2024 at 01:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |