Home » Developer & Programmer » Forms » PASSWORD TEXTBOX IS NOT WORKING (forms 6i and database 10g win xp)
PASSWORD TEXTBOX IS NOT WORKING [message #648513] Wed, 24 February 2016 07:58 Go to next message
alshadbik
Messages: 6
Registered: February 2016
Location: yemen
Junior Member
declare 

a CHAR(1) := 'a'; 
b CHAR(1) := 'b'; 
c CHAR(1) := 'c'; 
d CHAR(1) := 'd'; 
e CHAR(1) := 'e'; 
f CHAR(1) := 'f'; 
g CHAR(1) := 'g'; 
h CHAR(1) := 'h'; 
i CHAR(1) := 'i'; 
j CHAR(1) := 'j'; 
k CHAR(1) := 'k'; 
l CHAR(1) := 'l'; 
m CHAR(1) := 'm'; 
n CHAR(1) := 'n'; 
o CHAR(1) := 'o'; 
p CHAR(1) := 'p'; 
q CHAR(1) := 'q'; 
r CHAR(1) := 'r'; 
s CHAR(1) := 's'; 
t CHAR(1) := 't'; 
u CHAR(1) := 'u'; 
v CHAR(1) := 'v'; 
w CHAR(1) := 'w'; 
x CHAR(1) := 'x'; 
y CHAR(1) := 'y'; 
z CHAR(1) := 'z'; 

ca CHAR(1) := 'A'; 
cb CHAR(1) := 'B'; 
cc CHAR(1) := 'C'; 
cd CHAR(1) := 'D'; 
ce CHAR(1) := 'E'; 
cf CHAR(1) := 'F'; 
cg CHAR(1) := 'G'; 
ch CHAR(1) := 'H'; 
ci CHAR(1) := 'I'; 
cj CHAR(1) := 'J'; 
ck CHAR(1) := 'K'; 
cl CHAR(1) := 'L'; 
cm CHAR(1) := 'M'; 
cn CHAR(1) := 'N'; 
co CHAR(1) := 'O'; 
cp CHAR(1) := 'P'; 
cq CHAR(1) := 'Q'; 
cr CHAR(1) := 'R'; 
cs CHAR(1) := 'S'; 
ct CHAR(1) := 'T'; 
cu CHAR(1) := 'U'; 
cv CHAR(1) := 'V'; 
cw CHAR(1) := 'W'; 
cx CHAR(1) := 'X'; 
cy CHAR(1) := 'Y'; 
cz CHAR(1) := 'Z'; 

ATSIGN CHAR(1) := '@'; 
DOT CHAR(1) := '.'; 

ONE CHAR(1) := '1'; 
TWO CHAR(1) := '2'; 
THREE CHAR(1) := '3'; 
FOUR CHAR(1) := '4'; 
FIVE CHAR(1) := '5'; 
SIX CHAR(1) := '6'; 
SEVEN CHAR(1) := '7'; 
EIGHT CHAR(1) := '8'; 
NINE CHAR(1) := '9'; 
ZERO CHAR(1) := '0'; 

v_usr varchar2(30);
v_pwd varchar2(30);

begin 

v_usr := F||I||N||A||P||P;

v_pwd := F||I||N||A||P||P||ATSIGN||F||I||N||A||P||P;


LOGON(v_usr,v_pwd); 

end; 


/forum/fa/13045/0/


[EDITED by LF: applied CODE tags, inserted image into message body]

[Updated on: Thu, 25 February 2016 05:13] by Moderator

Report message to a moderator

Re: PASSWORD TEXTBOX IS NOT WORKING [message #648516 is a reply to message #648513] Wed, 24 February 2016 08:16 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
This begs so many questions:
It what way is it not working?
What trigger runs the code?
What on earth is the point of all those variables? You're not using them in any meaningfull way, or at all for most of them.
The following would do exactly the same:
begin

logon('finapp','finapp@finapp');

end;
Re: PASSWORD TEXTBOX IS NOT WORKING [message #648518 is a reply to message #648516] Wed, 24 February 2016 08:28 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Oh and please read and follow How to use [code] tags and make your code easier to read?
Re: PASSWORD TEXTBOX IS NOT WORKING [message #648536 is a reply to message #648516] Wed, 24 February 2016 12:57 Go to previous messageGo to next message
alshadbik
Messages: 6
Registered: February 2016
Location: yemen
Junior Member
When I try to login I write the name but the password does work at all
Re: PASSWORD TEXTBOX IS NOT WORKING [message #648537 is a reply to message #648516] Wed, 24 February 2016 12:58 Go to previous messageGo to next message
alshadbik
Messages: 6
Registered: February 2016
Location: yemen
Junior Member
Btw the privilliages are from this system
Re: PASSWORD TEXTBOX IS NOT WORKING [message #648547 is a reply to message #648536] Thu, 25 February 2016 03:19 Go to previous message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
alshadbik wrote on Wed, 24 February 2016 18:57
When I try to login I write the name but the password does work at all

That could mean all sorts of things, you have to be specific.
The code you've written doesn't rely on user input at all.
Previous Topic: deploying a .fmb form
Next Topic: text box higlighted black when form is opened
Goto Forum:
  


Current Time: Fri Jun 25 05:16:05 CDT 2021