General Find requests

Classic Servoy
1

This is one of the areas Servoy is not as easy as Filemaker, it seems.

I’m having quite a time figuring out how to get a Find request that will find words or strings in text fields regardless of letter case in that field. I’ve figured out that I can find the record for the Hastings Police Department by typing a Find request of “%Hastings%”.

Typing “%hastings%” won’t get the job done, though “%Hast%” will.

So what exactly is involved in scripting a (hopefully) global Find request that will place the % holders and resolve the Upper or Lower issue?

As expected, I’m doing great learning the general navigation, form, relationship way in Servoy, but the JavaScript is taking some time. I’ve read about each part of what I need to do, but putting it into practice is apparently a whole different animal.

thanks

dave

2

If you search the help for ‘find text’ check out the first result, it suggests to use the ‘#’ in front of your search string to search case insensitive
(case insensitive search is more expensive on all databases and therefore not default)