OraFAQ Forum: Forms » connect DataBAse for Form Level

Home » Developer & Programmer » Forms » connect DataBAse for Form Level (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

connect DataBAse for Form Level [message #281758]

Mon, 19 November 2007 04:25

roni_a180
Messages: 45
Registered: October 2007

Member

hi, i write a following code, i given uasername , password, and string in form level , and this is DataBase user,
when given username,user password is same in the database user and password then menu.fmx form is open others then message display
Message('Error -- not data base user .');
------------------

v_name := :block.username;
v_password := :block.password;
v_string := :block.string;

v_comm:=v_name||'/'||v_password||'@'||v_string;

host(v_comm);

then i write i condition

IF NOT Form_Success THEN

Message('Error -- not data base user .');

ELSE

call_form('menu.fmx');

end if;

ok
thanx

Report message to a moderator

Re: connect DataBAse for Form Level [message #281761 is a reply to message #281758]

Mon, 19 November 2007 04:43

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

Why not just calling the form? User will be prompted to enter his/her credentials anyway.

By the way, what good would HOST command do (the way you've written it)? HOST executes operating system commands. Your command is (just as an example)

C:>\ scott/tiger@xe

It is not a valid operating system command (not only on MS OS's, I believe it wouldn't work anywhere).

Report message to a moderator

Re: connect DataBAse for Form Level [message #281766 is a reply to message #281758]

Mon, 19 November 2007 05:00

roni_a180
Messages: 45
Registered: October 2007

Member

hi

cause first i build a logon screen , and there r 2 input string,
1 is user name , 2 is password.

when the user and password is same the database user name and password then logon screen execute and other forms is open

Report message to a moderator

Re: connect DataBAse for Form Level [message #281768 is a reply to message #281766]

Mon, 19 November 2007 05:04

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How do you run that "logon" form? Aren't you already connected to the database?

Report message to a moderator

Re: connect DataBAse for Form Level [message #281769 is a reply to message #281758]

Mon, 19 November 2007 05:06

roni_a180
Messages: 45
Registered: October 2007

Member

yes i connect database

but, for say there r 2 data base user

1 time i connect when the form is build.
then next time i login 2 data base user

Report message to a moderator

Re: connect DataBAse for Form Level [message #281798 is a reply to message #281769]

Mon, 19 November 2007 06:15

Littlefoot
Messages: 21824
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

But WHY are you making things complicated? What's wrong with specifying login credentials only once? Do you think your users will be happy with providing username/password twice, just to be able to start working? Where's the purpose in it?

Report message to a moderator

Re: connect DataBAse for Form Level [message #281887 is a reply to message #281758]

Mon, 19 November 2007 18:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Also, don't use form names like 'menu' or 'form' or 'forms'. Oracle systems just don't like us using THEIR names.

David

Report message to a moderator

Previous Topic:	HOW TO GET STORE image file
Next Topic:	Vertical Scroll bar

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 03 08:42:46 CDT 2025