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

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

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

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

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

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

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

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

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

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