I put on the window of the login interface, a data window control, the control and associated data window object, my connection is SQL Server2000. I used the following statement:
String correct_pwd, user_pwd, user_id
User_id=trim (sle_uid. Text)
User_pwd=trim (sle_upwd. Text)
Select the PWD into: correct_pwd from operator where id=: userid.
If (user_pwd=correct_pwd) then
Open (w_wnd_main)
Hide (w_wnd_login)
End the if
I default set a record in the database, after I input the correct user name and password, did not achieve the desired purpose, on track, I found the correct - the PWD is null, don't know where the problem, still hope everybody to help! ,
I am a novice! Thank you!

CodePudding user response:

Probably not found! How much is the number of rows to see meet terms?
Select count (*) from operator where id=: userid.

CodePudding user response:

The field types defined about with me? I define the field of id and PWD respectively char (4) and char (6)

CodePudding user response:

Is best defined as varchar2 type, or you trim values of the time to remove Spaces

CodePudding user response:

The select isnull (PWD, ' ') into: correct_pwd from operator where id=: userid.
Have a try

CodePudding user response:

Haven't met this situation.