Fill function NOT case sensitiv?

[oliver]

Hello,
me and all SM7 users are really confused about the stupid behaviour that the fill funtcion is case sensitiv. It may help in a few cases, but in these days every user expects from a software to function case insensitiv.

I considered already switching SM7 to case insensitiv, but I do not know what I will loose and what I will gain. I scared about side effects.

In fact the only thing that I want to gain is a fill, that doesn't care about case sensitivity.

Thanks for your hints.

Cheers

Oliver

[williajx]

In cases where we want to do a case-insensitive fill, we build the query manually in the link line and use the toupper/tolower functions:

$query="logical.name#\""+tolower(logical.name in $File)+"\" or logical.name#\""+toupper(logical.name in $File)+"\""

[oliver]

Hi williajx,

I started testing based on your query. It is not yet completely working as I want it to work, but I see already first positive results.

Thanks for your hint.

Oliver

[jstagaman]

The simplest way to address this is to use a consistent case for your source files, then set the case conversion on your form objects so the user doesn't have to know the case. I've done this with every SC system I've ever deployed and "case-sensitive fills" have never presented a problem. It is a simpler approach than modifying all of the link lines to include case conversion in the background.

[oliver]

Hmmm, I do partly agree.

Please don't forget we are in 2008 and not back in the 80th. Customers want and expect text is being entered as it is typically done. A software for thousands of dollars (or Euro) is unable to execute a fill or search just because the chars are not entered as the software (developer) wants it????

Look how Google works. SM7 should do it in the same way - oob.

I succeeded now in changing the query to do the fill case-insensitiv. If you know it, it is easy - as always.

I would like to know how you set your production environments regarding case sensitivity.

Do you set it up in case sensitiv mode?

Thanks for your responses.

[glg]

We just force uppercase on fields where it matters (categorization, assignment, etc)