You are viewing limited content. For full access, please sign in.

Question

Question

Is there an update for Forms so that SQL lookups don't have to be case sensitive?

asked on April 5, 2017

Hello,

 

I have a user who is on the most recent version of Forms and they are experiencing some issues that look to have been resolved in previous versions of Forms. 

 

An example of what is happening is as follows;

They are comparing a lookup field to the submitter of a forms username. The lookup pulls  example. ab\cnelson but the forms username is AB\CNELSON.

 

Since one is capitalized and the other isn't, it see's it as a non match.

 

Is anyone else seeing this? Is there any way to resolve this in the most recent version of Forms?

 

Thanks!

0 0

Replies

replied on April 5, 2017

Sorry, this will be mostly unhelpful. We're on Forms 10, and do a similar thing. The username comes through as mixed case (uppercase domain\lower case username), and the corresponding SQL value is all lower case. There's no issue getting a match for us with the differing cases. 

 

0 0
replied on April 6, 2017 Show version history

Can you share how did you design the lookup rule? I have no problem with Forms 10.2 as well.

0 0
replied on April 14, 2017

This kind of behavior is usually specified in the RDBMS rather than in the client application, since it will impact things like indexes.  What data source are you querying?

0 0
replied on April 17, 2017

Hello,

We were able to work around this by adding CSS to the form to force that incoming field to be all uppercase so that it's a match with the lookup.

 

Thanks!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.