I wrote a new user registration, compile, and other functions can be implemented, is registered can't write the data into the database... Under the guidance of the prawns, please.
String ps_id
String passid, pass, newpass
String err

Passid=sle_111. Text
Pass=sle_112. Text
Newpass=sle_113. Text


Err=""
If passid="" then
Err="user ID can't be empty! ~ n
"End the if
If pass="" then
Err=err + "password cannot be empty! ~ n
"End the if
If newpass="" then
Err=err + "repeat password cannot be empty! ~ n
"End the if
If pass<> Newpass then
Err=err + "password and repeat the password, please enter again! ~ n
"Sle_112. Text=""
Sle_113. Text=""
End the if
If err<& gt;" "Then
Messagebox (" error warning!" To err)
Return
End the if

Select "name"
Into: ps_id
The from the login
Using the sqlca.

If ps_id=passid then
Warning: messagebox (" system ", "the user ID has been found, please input again!" )
Sle_111. Text=""
Return
End the if
(INSERT INTO the login name and password)
VALUES (passid, pass)
Using the sqlca.

Messagebox (", ", "new user registration success!" )

CodePudding user response:

(INSERT INTO the login name and password)
VALUES (passid, pass)
Using the sqlca.
If the sqlca. Sqlcode=1 then
Messagebox (', 'failure')
The else
commit;
Messagebox (", ", "new user registration success!" )
end if

CodePudding user response:

Agree with the upstairs, SQL syntax errors, pass out of the colon

CodePudding user response:

Select "name"
Into: ps_id
The from the login
Using the sqlca.
This statement also has a problem, if you have multiple data table, can't get to the value

CodePudding user response:

Have been solved, thank you

CodePudding user response:

Have any PB can master to moonlight as a training instructor? If an interested friends, please send resume to: [email protected], please contact: QQ: 174629429 MSN:[email protected]