The _TALLY variable will not necessarily be set to the correct value, which is why we provide the LastSearchTally property.

The return value of the Search method will tell you if the search had errors (regardless of whether it found any matches). The Errors property will give you additional information in the case of errors during search. The LastSearchTally property will return the number of records matching your search criteria.

Are there 855 records that match the term "celeb*"? Do these get returned in the FTSearch cursor?

What is the value of FTSearchResult after you call Search? If it's .F., then you should check the Errors property.

Of course the fact that you use the wrong indicator to determine if the search yielded results does not explain why your wildcard search fails. You may want to use the example form with your own table to eliminate any errors in your search code. Just run the form and update the fields in the Create Index tab to select your own table.

Please post your findings here.

FoxWeb Support Teamsupport@foxweb.com email

Sent by Boudewijn lutgerink on 11/10/2015 03:16:24 PM:

here's the URL: https://www.youtube.com/watch?v=Lajf2MpBdUA

as you can see in the above video the only difference is the use of wildcards or not. When I do NOT use wildcards the crsSearch is found, when I do use wildcards the crsSearch is NOT found even though m.lSuccess returns .T.

Sent by FoxWeb Support on 11/06/2015 07:57:32 PM:

How large is the video? If it's up to 20MB, you can send it via email to support@foxweb.com. If not, I suggest that you post it as an unlisted video on YouTube and send us the URL.

FoxWeb Support Teamsupport@foxweb.com email

Sent by Boudewijn lutgerink on 11/06/2015 06:54:26 AM:

Working on my application I found a problem with doing searches with wildcards. I can make a video of it so you can see what I am doing and what I mean with it. Is there a way I send you this small video?