hi,

i'm using dbisam 3.19 i would like to filter records the easy way. My table PLAATS (it's dutch)
contains city name like :
Weert
Nederweert
Nederweert-Eind
Eind van den Hout


I used the following code :
 if (key=vk_return) then begin
    dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+' IN wpl_naam)';
    dmTables.tbl_plaats.Filtered:=true;
 end;

The user enters the name from the city where he's searching for into a edit box and hits enter, so...let's say he wants
to search voor the term : weert
The result must be that all 3 cities must be found....but...only the city Weert is found and not the other ones
where the term 'weer' exists in lower case.

I created a secondary index (case ins=NO) based on the field wpl_naam (which represents the city names), also
created a full text seach index but never got the result i need.

what's wrong with this filter

greetz Peter

Peter,

What are the names of all that searched cities?

Regards,
Janusz



U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:FC3DD090-4B48-46D6-952D-D22B15261FFA@news.elevatesoft.com...
> hi,
>
> i'm using dbisam 3.19 i would like to filter records the easy way. My
> table PLAATS (it's dutch)
> contains city name like :
> Weert
> Nederweert
> Nederweert-Eind
> Eind van den Hout
>
>
> I used the following code :
>  if (key=vk_return) then begin
>
> dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+'
> IN wpl_naam)';
>     dmTables.tbl_plaats.Filtered:=true;
>  end;
>
> The user enters the name from the city where he's searching for into a
> edit box and hits enter, so...let's say he wants
> to search voor the term : weert
> The result must be that all 3 cities must be found....but...only the city
> Weert is found and not the other ones
> where the term 'weer' exists in lower case.
>
> I created a secondary index (case ins=NO) based on the field wpl_naam
> (which represents the city names), also
> created a full text seach index but never got the result i need.
>
> what's wrong with this filter
>
> greetz Peter
>
>

Hi,

I'm searching for the city 'Weert' and there about 2500 city names and a couple
of them are :
- Nederweert
- Nederweert-Eind
- Weert


"Janusz Cyran" <lobster@hot.pl> wrote:

Peter,

What are the names of all that searched cities?

Regards,
Janusz



U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:FC3DD090-4B48-46D6-952D-D22B15261FFA@news.elevatesoft.com...
> hi,
>
> i'm using dbisam 3.19 i would like to filter records the easy way. My
> table PLAATS (it's dutch)
> contains city name like :
> Weert
> Nederweert
> Nederweert-Eind
> Eind van den Hout
>
>
> I used the following code :
>  if (key=vk_return) then begin
>
> dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+'
> IN wpl_naam)';
>     dmTables.tbl_plaats.Filtered:=true;
>  end;
>
> The user enters the name from the city where he's searching for into a
> edit box and hits enter, so...let's say he wants
> to search voor the term : weert
> The result must be that all 3 cities must be found....but...only the city
> Weert is found and not the other ones
> where the term 'weer' exists in lower case.
>
> I created a secondary index (case ins=NO) based on the field wpl_naam
> (which represents the city names), also
> created a full text seach index but never got the result i need.
>
> what's wrong with this filter
>
> greetz Peter
>
>

Peter,

If I'm right TEXTSEARCH will find all words beginnig with 'Weert', but not
all strings which includes 'weert'.
So it would find both Nederweert and Nederweert-Eind when you look for
'neder*'.

Janusz




U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:63A10636-8887-4B51-842A-1FB680BE0D74@news.elevatesoft.com...
> Hi,
>
> I'm searching for the city 'Weert' and there about 2500 city names and a
> couple
> of them are :
> - Nederweert
> - Nederweert-Eind
> - Weert
>
>
> "Janusz Cyran" <lobster@hot.pl> wrote:
>
> Peter,
>
> What are the names of all that searched cities?
>
> Regards,
> Janusz
>
>
>
> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
> news:FC3DD090-4B48-46D6-952D-D22B15261FFA@news.elevatesoft.com...
>> hi,
>>
>> i'm using dbisam 3.19 i would like to filter records the easy way. My
>> table PLAATS (it's dutch)
>> contains city name like :
>> Weert
>> Nederweert
>> Nederweert-Eind
>> Eind van den Hout
>>
>>
>> I used the following code :
>>  if (key=vk_return) then begin
>>
>> dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+'
>> IN wpl_naam)';
>>     dmTables.tbl_plaats.Filtered:=true;
>>  end;
>>
>> The user enters the name from the city where he's searching for into a
>> edit box and hits enter, so...let's say he wants
>> to search voor the term : weert
>> The result must be that all 3 cities must be found....but...only the city
>> Weert is found and not the other ones
>> where the term 'weer' exists in lower case.
>>
>> I created a secondary index (case ins=NO) based on the field wpl_naam
>> (which represents the city names), also
>> created a full text seach index but never got the result i need.
>>
>> what's wrong with this filter
>>
>> greetz Peter
>>
>>
>
>

Hi Janusz,

Well...when searching for 'neder' both cities Nederweert and Nederweert-Eind
are NOT found. They will be found like you wrote when searching for 'neder*'

Is it possible to filter for a string so when searching for weert that
all cities will be found which contain the string 'weert'

greetz PEter


"Janusz Cyran" <lobster@hot.pl> wrote:

Peter,

If I'm right TEXTSEARCH will find all words beginnig with 'Weert', but not
all strings which includes 'weert'.
So it would find both Nederweert and Nederweert-Eind when you look for
'neder*'.

Janusz




U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:63A10636-8887-4B51-842A-1FB680BE0D74@news.elevatesoft.com...
> Hi,
>
> I'm searching for the city 'Weert' and there about 2500 city names and a
> couple
> of them are :
> - Nederweert
> - Nederweert-Eind
> - Weert
>
>
> "Janusz Cyran" <lobster@hot.pl> wrote:
>
> Peter,
>
> What are the names of all that searched cities?
>
> Regards,
> Janusz
>
>
>
> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
> news:FC3DD090-4B48-46D6-952D-D22B15261FFA@news.elevatesoft.com...
>> hi,
>>
>> i'm using dbisam 3.19 i would like to filter records the easy way. My
>> table PLAATS (it's dutch)
>> contains city name like :
>> Weert
>> Nederweert
>> Nederweert-Eind
>> Eind van den Hout
>>
>>
>> I used the following code :
>>  if (key=vk_return) then begin
>>
>> dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+'
>> IN wpl_naam)';
>>     dmTables.tbl_plaats.Filtered:=true;
>>  end;
>>
>> The user enters the name from the city where he's searching for into a
>> edit box and hits enter, so...let's say he wants
>> to search voor the term : weert
>> The result must be that all 3 cities must be found....but...only the city
>> Weert is found and not the other ones
>> where the term 'weer' exists in lower case.
>>
>> I created a secondary index (case ins=NO) based on the field wpl_naam
>> (which represents the city names), also
>> created a full text seach index but never got the result i need.
>>
>> what's wrong with this filter
>>
>> greetz Peter
>>
>>
>
>

Peter

I suppose you can use an ordinary filter, for instance with Pos() function
to determine if the substring is inluded in the city name. But it won't be
optizmized, I'm afraid.

Janusz



U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:732E07A7-D32B-431A-A6CF-26E30A5FF5FC@news.elevatesoft.com...
> Hi Janusz,
>
> Well...when searching for 'neder' both cities Nederweert and
> Nederweert-Eind
> are NOT found. They will be found like you wrote when searching for
> 'neder*'
>
> Is it possible to filter for a string so when searching for weert that
> all cities will be found which contain the string 'weert'
>
> greetz PEter
>
>
> "Janusz Cyran" <lobster@hot.pl> wrote:
>
> Peter,
>
> If I'm right TEXTSEARCH will find all words beginnig with 'Weert', but not
> all strings which includes 'weert'.
> So it would find both Nederweert and Nederweert-Eind when you look for
> 'neder*'.
>
> Janusz
>
>
>
>
> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
> news:63A10636-8887-4B51-842A-1FB680BE0D74@news.elevatesoft.com...
>> Hi,
>>
>> I'm searching for the city 'Weert' and there about 2500 city names and a
>> couple
>> of them are :
>> - Nederweert
>> - Nederweert-Eind
>> - Weert
>>
>>
>> "Janusz Cyran" <lobster@hot.pl> wrote:
>>
>> Peter,
>>
>> What are the names of all that searched cities?
>>
>> Regards,
>> Janusz
>>
>>
>>
>> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
>> news:FC3DD090-4B48-46D6-952D-D22B15261FFA@news.elevatesoft.com...
>>> hi,
>>>
>>> i'm using dbisam 3.19 i would like to filter records the easy way. My
>>> table PLAATS (it's dutch)
>>> contains city name like :
>>> Weert
>>> Nederweert
>>> Nederweert-Eind
>>> Eind van den Hout
>>>
>>>
>>> I used the following code :
>>>  if (key=vk_return) then begin
>>>
>>> dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+'
>>> IN wpl_naam)';
>>>     dmTables.tbl_plaats.Filtered:=true;
>>>  end;
>>>
>>> The user enters the name from the city where he's searching for into a
>>> edit box and hits enter, so...let's say he wants
>>> to search voor the term : weert
>>> The result must be that all 3 cities must be found....but...only the
>>> city
>>> Weert is found and not the other ones
>>> where the term 'weer' exists in lower case.
>>>
>>> I created a secondary index (case ins=NO) based on the field wpl_naam
>>> (which represents the city names), also
>>> created a full text seach index but never got the result i need.
>>>
>>> what's wrong with this filter
>>>
>>> greetz Peter
>>>
>>>
>>
>>
>
>

Janusz,

thanks for you help and hope i can find a other solution for creating this filter.
Maybe i have to look for a other option and leave the filtering method.

Can it be done with findkey or locate that you know, can't find a
good example using findkey.

"Janusz Cyran" <lobster@hot.pl> wrote:

Peter

I suppose you can use an ordinary filter, for instance with Pos() function
to determine if the substring is inluded in the city name. But it won't be
optizmized, I'm afraid.

Janusz



U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:732E07A7-D32B-431A-A6CF-26E30A5FF5FC@news.elevatesoft.com...
> Hi Janusz,
>
> Well...when searching for 'neder' both cities Nederweert and
> Nederweert-Eind
> are NOT found. They will be found like you wrote when searching for
> 'neder*'
>
> Is it possible to filter for a string so when searching for weert that
> all cities will be found which contain the string 'weert'
>
> greetz PEter
>
>
> "Janusz Cyran" <lobster@hot.pl> wrote:
>
> Peter,
>
> If I'm right TEXTSEARCH will find all words beginnig with 'Weert', but not
> all strings which includes 'weert'.
> So it would find both Nederweert and Nederweert-Eind when you look for
> 'neder*'.
>
> Janusz
>
>
>
>
> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
> news:63A10636-8887-4B51-842A-1FB680BE0D74@news.elevatesoft.com...
>> Hi,
>>
>> I'm searching for the city 'Weert' and there about 2500 city names and a
>> couple
>> of them are :
>> - Nederweert
>> - Nederweert-Eind
>> - Weert
>>
>>
>> "Janusz Cyran" <lobster@hot.pl> wrote:
>>
>> Peter,
>>
>> What are the names of all that searched cities?
>>
>> Regards,
>> Janusz
>>
>>
>>
>> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
>> news:FC3DD090-4B48-46D6-952D-D22B15261FFA@news.elevatesoft.com...
>>> hi,
>>>
>>> i'm using dbisam 3.19 i would like to filter records the easy way. My
>>> table PLAATS (it's dutch)
>>> contains city name like :
>>> Weert
>>> Nederweert
>>> Nederweert-Eind
>>> Eind van den Hout
>>>
>>>
>>> I used the following code :
>>>  if (key=vk_return) then begin
>>>
>>> dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+'
>>> IN wpl_naam)';
>>>     dmTables.tbl_plaats.Filtered:=true;
>>>  end;
>>>
>>> The user enters the name from the city where he's searching for into a
>>> edit box and hits enter, so...let's say he wants
>>> to search voor the term : weert
>>> The result must be that all 3 cities must be found....but...only the
>>> city
>>> Weert is found and not the other ones
>>> where the term 'weer' exists in lower case.
>>>
>>> I created a secondary index (case ins=NO) based on the field wpl_naam
>>> (which represents the city names), also
>>> created a full text seach index but never got the result i need.
>>>
>>> what's wrong with this filter
>>>
>>> greetz Peter
>>>
>>>
>>
>>
>
>

I've had the same problem some time ago (finding the substrings) and I used
a query - surely it works, although the problem of optimization remains. On
the other hand 2500 records is a relatively small number and it should work
fine (both ordinary filter and a query). I don't know how it is in the newer
DBISAM version (I mean TEXTSEARCH possibilities).

Regards,
Janusz


U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:BFD90642-8A11-4EA9-A8A9-448AC8B16A5A@news.elevatesoft.com...
> Janusz,
>
> thanks for you help and hope i can find a other solution for creating this
> filter.
> Maybe i have to look for a other option and leave the filtering method.
>
> Can it be done with findkey or locate that you know, can't find a
> good example using findkey.
>
> "Janusz Cyran" <lobster@hot.pl> wrote:
>
> Peter
>
> I suppose you can use an ordinary filter, for instance with Pos() function
> to determine if the substring is inluded in the city name. But it won't be
> optizmized, I'm afraid.
>
> Janusz
>
>
>
> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
> news:732E07A7-D32B-431A-A6CF-26E30A5FF5FC@news.elevatesoft.com...
>> Hi Janusz,
>>
>> Well...when searching for 'neder' both cities Nederweert and
>> Nederweert-Eind
>> are NOT found. They will be found like you wrote when searching for
>> 'neder*'
>>
>> Is it possible to filter for a string so when searching for weert that
>> all cities will be found which contain the string 'weert'
>>
>> greetz PEter
>>
>>
>> "Janusz Cyran" <lobster@hot.pl> wrote:
>>
>> Peter,
>>
>> If I'm right TEXTSEARCH will find all words beginnig with 'Weert', but
>> not
>> all strings which includes 'weert'.
>> So it would find both Nederweert and Nederweert-Eind when you look for
>> 'neder*'.
>>
>> Janusz
>>
>>
>>
>>
>> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
>> news:63A10636-8887-4B51-842A-1FB680BE0D74@news.elevatesoft.com...
>>> Hi,
>>>
>>> I'm searching for the city 'Weert' and there about 2500 city names and a
>>> couple
>>> of them are :
>>> - Nederweert
>>> - Nederweert-Eind
>>> - Weert
>>>
>>>
>>> "Janusz Cyran" <lobster@hot.pl> wrote:
>>>
>>> Peter,
>>>
>>> What are the names of all that searched cities?
>>>
>>> Regards,
>>> Janusz
>>>
>>>
>>>
>>> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
>>> news:FC3DD090-4B48-46D6-952D-D22B15261FFA@news.elevatesoft.com...
>>>> hi,
>>>>
>>>> i'm using dbisam 3.19 i would like to filter records the easy way. My
>>>> table PLAATS (it's dutch)
>>>> contains city name like :
>>>> Weert
>>>> Nederweert
>>>> Nederweert-Eind
>>>> Eind van den Hout
>>>>
>>>>
>>>> I used the following code :
>>>>  if (key=vk_return) then begin
>>>>
>>>> dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+'
>>>> IN wpl_naam)';
>>>>     dmTables.tbl_plaats.Filtered:=true;
>>>>  end;
>>>>
>>>> The user enters the name from the city where he's searching for into a
>>>> edit box and hits enter, so...let's say he wants
>>>> to search voor the term : weert
>>>> The result must be that all 3 cities must be found....but...only the
>>>> city
>>>> Weert is found and not the other ones
>>>> where the term 'weer' exists in lower case.
>>>>
>>>> I created a secondary index (case ins=NO) based on the field wpl_naam
>>>> (which represents the city names), also
>>>> created a full text seach index but never got the result i need.
>>>>
>>>> what's wrong with this filter
>>>>
>>>> greetz Peter
>>>>
>>>>
>>>
>>>
>>
>>
>
>

hi,

with a query it's possible and works, but i'm using a tdbisamtable component
for manage data. my form contains a dbedit for editting city names and a
dbgrid for displaying the content of the table. When using a query for filtering
how can a display the result in the same dbgrid on the form, i don't think
thats possible, isn't it ?


"Janusz Cyran" <lobster@hot.pl> wrote:

I've had the same problem some time ago (finding the substrings) and I used
a query - surely it works, although the problem of optimization remains. On
the other hand 2500 records is a relatively small number and it should work
fine (both ordinary filter and a query). I don't know how it is in the newer
DBISAM version (I mean TEXTSEARCH possibilities).

Regards,
Janusz


U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:BFD90642-8A11-4EA9-A8A9-448AC8B16A5A@news.elevatesoft.com...
> Janusz,
>
> thanks for you help and hope i can find a other solution for creating this
> filter.
> Maybe i have to look for a other option and leave the filtering method.
>
> Can it be done with findkey or locate that you know, can't find a
> good example using findkey.
>
> "Janusz Cyran" <lobster@hot.pl> wrote:
>
> Peter
>
> I suppose you can use an ordinary filter, for instance with Pos() function
> to determine if the substring is inluded in the city name. But it won't be
> optizmized, I'm afraid.
>
> Janusz
>
>
>
> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
> news:732E07A7-D32B-431A-A6CF-26E30A5FF5FC@news.elevatesoft.com...
>> Hi Janusz,
>>
>> Well...when searching for 'neder' both cities Nederweert and
>> Nederweert-Eind
>> are NOT found. They will be found like you wrote when searching for
>> 'neder*'
>>
>> Is it possible to filter for a string so when searching for weert that
>> all cities will be found which contain the string 'weert'
>>
>> greetz PEter
>>
>>
>> "Janusz Cyran" <lobster@hot.pl> wrote:
>>
>> Peter,
>>
>> If I'm right TEXTSEARCH will find all words beginnig with 'Weert', but
>> not
>> all strings which includes 'weert'.
>> So it would find both Nederweert and Nederweert-Eind when you look for
>> 'neder*'.
>>
>> Janusz
>>
>>
>>
>>
>> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
>> news:63A10636-8887-4B51-842A-1FB680BE0D74@news.elevatesoft.com...
>>> Hi,
>>>
>>> I'm searching for the city 'Weert' and there about 2500 city names and a
>>> couple
>>> of them are :
>>> - Nederweert
>>> - Nederweert-Eind
>>> - Weert
>>>
>>>
>>> "Janusz Cyran" <lobster@hot.pl> wrote:
>>>
>>> Peter,
>>>
>>> What are the names of all that searched cities?
>>>
>>> Regards,
>>> Janusz
>>>
>>>
>>>
>>> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
>>> news:FC3DD090-4B48-46D6-952D-D22B15261FFA@news.elevatesoft.com...
>>>> hi,
>>>>
>>>> i'm using dbisam 3.19 i would like to filter records the easy way. My
>>>> table PLAATS (it's dutch)
>>>> contains city name like :
>>>> Weert
>>>> Nederweert
>>>> Nederweert-Eind
>>>> Eind van den Hout
>>>>
>>>>
>>>> I used the following code :
>>>>  if (key=vk_return) then begin
>>>>
>>>> dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+'
>>>> IN wpl_naam)';
>>>>     dmTables.tbl_plaats.Filtered:=true;
>>>>  end;
>>>>
>>>> The user enters the name from the city where he's searching for into a
>>>> edit box and hits enter, so...let's say he wants
>>>> to search voor the term : weert
>>>> The result must be that all 3 cities must be found....but...only the
>>>> city
>>>> Weert is found and not the other ones
>>>> where the term 'weer' exists in lower case.
>>>>
>>>> I created a secondary index (case ins=NO) based on the field wpl_naam
>>>> (which represents the city names), also
>>>> created a full text seach index but never got the result i need.
>>>>
>>>> what's wrong with this filter
>>>>
>>>> greetz Peter
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Peter,

My suggestion with Pos() function was wrong, you cannot use Pos() in filter
expressions - but you can use something like this:
CityName LIKE '%weert%'.

Perhaps it should be some solution for you.

Regards,
Janusz



U¿ytkownik "peter van mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
news:1D84EBAE-55B9-499F-A7B6-0EF0DE55639E@news.elevatesoft.com...
> hi,
>
> with a query it's possible and works, but i'm using a tdbisamtable
> component
> for manage data. my form contains a dbedit for editting city names and a
> dbgrid for displaying the content of the table. When using a query for
> filtering
> how can a display the result in the same dbgrid on the form, i don't think
> thats possible, isn't it ?
>
>
> "Janusz Cyran" <lobster@hot.pl> wrote:
>
> I've had the same problem some time ago (finding the substrings) and I
> used
> a query - surely it works, although the problem of optimization remains.
> On
> the other hand 2500 records is a relatively small number and it should
> work
> fine (both ordinary filter and a query). I don't know how it is in the
> newer
> DBISAM version (I mean TEXTSEARCH possibilities).
>
> Regards,
> Janusz
>
>
> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
> news:BFD90642-8A11-4EA9-A8A9-448AC8B16A5A@news.elevatesoft.com...
>> Janusz,
>>
>> thanks for you help and hope i can find a other solution for creating
>> this
>> filter.
>> Maybe i have to look for a other option and leave the filtering method.
>>
>> Can it be done with findkey or locate that you know, can't find a
>> good example using findkey.
>>
>> "Janusz Cyran" <lobster@hot.pl> wrote:
>>
>> Peter
>>
>> I suppose you can use an ordinary filter, for instance with Pos()
>> function
>> to determine if the substring is inluded in the city name. But it won't
>> be
>> optizmized, I'm afraid.
>>
>> Janusz
>>
>>
>>
>> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
>> news:732E07A7-D32B-431A-A6CF-26E30A5FF5FC@news.elevatesoft.com...
>>> Hi Janusz,
>>>
>>> Well...when searching for 'neder' both cities Nederweert and
>>> Nederweert-Eind
>>> are NOT found. They will be found like you wrote when searching for
>>> 'neder*'
>>>
>>> Is it possible to filter for a string so when searching for weert that
>>> all cities will be found which contain the string 'weert'
>>>
>>> greetz PEter
>>>
>>>
>>> "Janusz Cyran" <lobster@hot.pl> wrote:
>>>
>>> Peter,
>>>
>>> If I'm right TEXTSEARCH will find all words beginnig with 'Weert', but
>>> not
>>> all strings which includes 'weert'.
>>> So it would find both Nederweert and Nederweert-Eind when you look for
>>> 'neder*'.
>>>
>>> Janusz
>>>
>>>
>>>
>>>
>>> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
>>> news:63A10636-8887-4B51-842A-1FB680BE0D74@news.elevatesoft.com...
>>>> Hi,
>>>>
>>>> I'm searching for the city 'Weert' and there about 2500 city names and
>>>> a
>>>> couple
>>>> of them are :
>>>> - Nederweert
>>>> - Nederweert-Eind
>>>> - Weert
>>>>
>>>>
>>>> "Janusz Cyran" <lobster@hot.pl> wrote:
>>>>
>>>> Peter,
>>>>
>>>> What are the names of all that searched cities?
>>>>
>>>> Regards,
>>>> Janusz
>>>>
>>>>
>>>>
>>>> U¿ytkownik "Peter van Mierlo" <p.mierlo@planet.nl> napisa³ w wiadomo¶ci
>>>> news:FC3DD090-4B48-46D6-952D-D22B15261FFA@news.elevatesoft.com...
>>>>> hi,
>>>>>
>>>>> i'm using dbisam 3.19 i would like to filter records the easy way. My
>>>>> table PLAATS (it's dutch)
>>>>> contains city name like :
>>>>> Weert
>>>>> Nederweert
>>>>> Nederweert-Eind
>>>>> Eind van den Hout
>>>>>
>>>>>
>>>>> I used the following code :
>>>>>  if (key=vk_return) then begin
>>>>>
>>>>> dmTables.tbl_plaats.Filter:='TEXTSEARCH('+QuotedStr(lowercase(RzButtonEdit_wplZoek.Text)+'*')+'
>>>>> IN wpl_naam)';
>>>>>     dmTables.tbl_plaats.Filtered:=true;
>>>>>  end;
>>>>>
>>>>> The user enters the name from the city where he's searching for into a
>>>>> edit box and hits enter, so...let's say he wants
>>>>> to search voor the term : weert
>>>>> The result must be that all 3 cities must be found....but...only the
>>>>> city
>>>>> Weert is found and not the other ones
>>>>> where the term 'weer' exists in lower case.
>>>>>
>>>>> I created a secondary index (case ins=NO) based on the field wpl_naam
>>>>> (which represents the city names), also
>>>>> created a full text seach index but never got the result i need.
>>>>>
>>>>> what's wrong with this filter
>>>>>
>>>>> greetz Peter
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>