Ignore case on search and find

Classic Servoy
1

Hi

I am sure this is a beginner question.

I have successfully got a find and search working but it is case sensitive…

I don’t want it to be.

Has it got to do with how to use “#”?

:) I know trhis is probably laff-able.

Appreciate unswer.

Jonathon

2

Hi Jonathon,

Yes, it has indeed to do with the “#” (assuming you are not using SQL but the Servoy search functions).
You need to add it at the beginning of your search string.

if ( controller.find() ) {
    mySearchField = "#yourSearchCriteria";
    controller.search();
} else {
    // couldn't get into find mode
}

Hope this helps.

P.s. beginners questions are very welcome. Remember. There are no stupid questions, only stupid answers.
I hope my answer doesn’t fall in that category ;)

3

Thank you…

That is a neat way of doing it! I was looking for a more visual foxpro way… this is cleaner and quicker.

Kind Regards
Jonathon