NiceMan331
asked on
using inputbox in the form
i have a tabular form ,
in post_text_item will check a value if it is exist in the table
otherwise it will insert a record , but it require to receive one value from a user
here is my code
is there any way as ms access to send inputbox , the user type in , then use this value to insert into record ?
in post_text_item will check a value if it is exist in the table
otherwise it will insert a record , but it require to receive one value from a user
here is my code
declare
alert_button number;
begin
if :V_STAT_D.RESRV is not null then
if Empl_Exists(:v_emp.emp_no,:V_STAT_D.RESRV) = 0 then (if record not exist)
alert_button:=show_alert('A_CONF');
if alert_button=alert_button1 then -- alert asking user to confirm add new record
-- here we need the form to receive one value from the user
then insert into
is there any way as ms access to send inputbox , the user type in , then use this value to insert into record ?
ASKER
wellcome back my teacher , i missed u
long time i not hear any replay from u
could u guide me on how to use this global variable
long time i not hear any replay from u
I suggest to user :global.variables
could u guide me on how to use this global variable
Create a procedure (for example in a library that may be used also in other forms)which library ? in this form ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok great ,
i did it but for my bad luck , the fmx of inputbox box fail to open ,
inspit of the fmb opened
i just added one button and one text item , then the code of global
:global.inputbox_text := :text_item;
is it necessary to add also the button variables
when button pressed trigger on button1
:global.inputbox_button := 'BUTTON1';
when button pressed trigger on button2
:global.inputbox_button := 'BUTTON2';
second :
then i adjust the procedure like this
PROCEDURE SHOW_INPUTBOX( p_text OUT VARCHAR2)
IS
BEGIN
-- initialise the globals
COPY(NULL,'GLOBAL.INPUTBOX _TEXT');
CALL_FORM('F_INPUTBOX');
-- use the globals
p_text := NAME_IN('GLOBAL.INPUTBOX_T EXT');
-- remove the globals
ERASE('GLOBAL.INPUTBOX_TEX T');
END;
is it ok ? because i need only the value of the text , i dont have any other text
or i should add the missed codes of button ?
third
regarding calling the global , is it true like this :
declare
m_name varchar2(70);
begin
SHOW_INPUTBOX(m_name);
insert into person_cons(person_name)
values(m_name);
commit;
END;
i did it but for my bad luck , the fmx of inputbox box fail to open ,
inspit of the fmb opened
i just added one button and one text item , then the code of global
:global.inputbox_text := :text_item;
is it necessary to add also the button variables
when button pressed trigger on button1
:global.inputbox_button := 'BUTTON1';
when button pressed trigger on button2
:global.inputbox_button := 'BUTTON2';
second :
then i adjust the procedure like this
PROCEDURE SHOW_INPUTBOX( p_text OUT VARCHAR2)
IS
BEGIN
-- initialise the globals
COPY(NULL,'GLOBAL.INPUTBOX
CALL_FORM('F_INPUTBOX');
-- use the globals
p_text := NAME_IN('GLOBAL.INPUTBOX_T
-- remove the globals
ERASE('GLOBAL.INPUTBOX_TEX
END;
is it ok ? because i need only the value of the text , i dont have any other text
or i should add the missed codes of button ?
third
regarding calling the global , is it true like this :
declare
m_name varchar2(70);
begin
SHOW_INPUTBOX(m_name);
insert into person_cons(person_name)
values(m_name);
commit;
END;
If you don't need the button information,but just the text i think you are making the good modifications.
But I don't understand your problem :
the fmx of inputbox box fail to open , inspit of the fmb opened
Do you mean it works if you use the run-option in the form builder but not if you call the form from another another form ?
But I don't understand your problem :
the fmx of inputbox box fail to open , inspit of the fmb opened
Do you mean it works if you use the run-option in the form builder but not if you call the form from another another form ?
ASKER
Yes , it run via form builder , but not run when calling it from another form , also I try to run it from form run time but not run also
You are able to run other forms at runtime ?
ASKER
yes , i run many forms at runtime without any problem
ASKER
sorry
today i run it without any modification , it run
the code working very well now thanx
still one thing
when i call the inputbox form , how i can avoid showing the runtime standard form of oracle
today i run it without any modification , it run
the code working very well now thanx
still one thing
when i call the inputbox form , how i can avoid showing the runtime standard form of oracle
What do you mean by "runtime standard form" ?
If you mean that the form from where you call the imput-box is hidden if the inputbox-form is shown, then adjust the size of the window (and canvas) till it gets a real box the size you want.
If you mean that the form from where you call the imput-box is hidden if the inputbox-form is shown, then adjust the size of the window (and canvas) till it gets a real box the size you want.
ASKER
I already adjusted the canvas & window size to fit with my requirement , but still when calling the input box form , there is full size of oracle runtime form
I will check settings for a simular form-type at work on monday.
If you want to experiment check window-style (> dialog) and modal (>yes) of the windows properties.
Is that window also the window mentioned in the form-properties ?
If you want to experiment check window-style (> dialog) and modal (>yes) of the windows properties.
Is that window also the window mentioned in the form-properties ?
ASKER
snapshot for the form
plz look the shoot , sorry for the teamviwer shot inside
Screenshot-2014-03-08-21.31.00.png
plz look the shoot , sorry for the teamviwer shot inside
Screenshot-2014-03-08-21.31.00.png
What version of oracle forms you are using ?
If you use the inputbox calling it from another form is it a problem ?
If you use the inputbox calling it from another form is it a problem ?
ASKER
i'm using oracle forms 6i
actually this problem not exculsive to the inbut box form
the screen of the oracle form appearing with all my forms
actually this problem not exculsive to the inbut box form
the screen of the oracle form appearing with all my forms
Forms 6i runtime: I think I can't help you.
In later versions you can define the size of the applet within the forms*.cfg configuration file, but even then we did use it with internet explorer so that applet is shown in the standard browser window,
In later versions you can define the size of the applet within the forms*.cfg configuration file, but even then we did use it with internet explorer so that applet is shown in the standard browser window,
ASKER
ok
any how , you already answered my question , it is well now
shall i open new question for that subject ?
thanx
any how , you already answered my question , it is well now
shall i open new question for that subject ?
thanx
You might consider building another form with a small canvass, some push-buttons and a text item and mimick the behaviour of the msaccess inputbox.
Create a procedure (for example in a library that may be used also in other forms) that calls the form and return the pressed button and and the value.
I suggest to user :global.variables to enable the communication between inputbox-form and procedure.