The fact that the Search method returned .T. does not mean that the search yielded results. This is what the LastSearchTally property is for. Search only returns .F. if there's an error.
Take a look at the code used by the sample form ftexample.scx:
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.
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 firstname.lastname@example.org. If not, I suggest that you post it as an unlisted video on YouTube and send us the URL.
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?