1. Deva Shanmuga
  2. PowerBuilder
  3. Monday, 15 July 2024 09:17 AM UTC

Hello Experts,

In my application's login screen, the user inputs their login ID and password through text fields. However, PowerBuilder is not validating the case sensitivity of the password. For instance, if the original password is "Abcd1234" and the user enters "abcd1234", it is still being accepted. How can I resolve this issue?

Thanks

Deva S

Andreas Mykonios Accepted Answer Pending Moderation
  1. Monday, 15 July 2024 09:34 AM UTC
  2. PowerBuilder
  3. # 1

Hi.

Is this a password to connect to a database? If yes, then you should have that setting set (enabled) in your database, not in powerbuilder.

Andreas.

Comment
  1. Deva Shanmuga
  2. Monday, 15 July 2024 09:57 AM UTC
Hi Andreas, No it is not the password for connecting the database. This credentials is used for login the application.
  1. Helpful
There are no comments made yet.
Andreas Mykonios Accepted Answer Pending Moderation
  1. Monday, 15 July 2024 10:40 AM UTC
  2. PowerBuilder
  3. # 2

A string comparison in powerbuilder of "Abcd1234" vs "abcd1234" should result in false.

What you see when running the following code?

string ls_value1, ls_value2

ls_value1 = "Abcd1234"
ls_value2 = "abcd1234"

if ls_value1 = ls_value2 then
	messagebox("", "Equal")
else
	messagebox("", "Different")
end if

Andreas.

Comment
  1. Deva Shanmuga
  2. Monday, 15 July 2024 13:02 PM UTC
Hello Andreas, In my scenario, I am getting the password and I will pass as retrieval argument value for a datawindow, Even though the values are differ by case sensitive, the data is getting retrieved
  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 15 July 2024 13:22 PM UTC
Hi Andreas / Deva;

Most DBMS have a case sensitivity setting. If off, the password would only be checked for digit compliance. If on, then the case sensitivity check (in your case) would fail.

You guys do bring up an interesting enhancement suggestion though to have a Set case sensitivity (boolean) PowerScript function to also have the PBVM follow that same DBMS feature.

In the meantime, using a character for character check in PowerScript would be the workaround for now. HTH

Regards ... Chris

  1. Helpful 2
  1. Deva Shanmuga
  2. Tuesday, 16 July 2024 05:56 AM UTC
Got it. Thanks Chris.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.