There are 4 values so it should be :1, :2, :3, :4
It works now!
New question:
Code: Select all
If field "SignUp_Password" = field "SignUp_RePassword"
else answer error"The passwords you entered are not the same."
exit to top
end if
Thanks Michael
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller
Code: Select all
If field "SignUp_Password" = field "SignUp_RePassword"
else answer error"The passwords you entered are not the same."
exit to top
end if
Code: Select all
...
## <> = IS NOT
If field "SignUp_Password" <> field "SignUp_RePassword"
answer error"The passwords you entered are not the same."
exit to top
end if
...
Code: Select all
put "Account" into tTableName
put field "SignIn_Name" into tName
put field "SignIn_Password" into tPassword
put "SELECT PASSWORD FROM " & tTableName & "WHERE Name=tName" into tSQL
put revDataFromQuery(tab, cr, gConnectionID, tSQL) into tData
if tData <> tPassword then
answer error "Incorrect Name or Password. Please re-enter."
exit to top
end if
Code: Select all
put "SELECT PASSWORD FROM " & tTableName & "WHERE Name=tName" into tSQL
Code: Select all
put "SELECT PASSWORD FROM " & tTableName & "WHERE Name=" & tName into tSQL
Code: Select all
...
answer tSQL
...
Code: Select all
put "blah blah blah" & cr after msg
Code: Select all
put "SELECT Password FROM " & tTableName & " WHERE Name=" & tName into tSQL
Code: Select all
put "SELECT Password FROM " & tTableName & " WHERE Name='" & tName &"'" into tSQL