How i can passing parameters between oracle forms ??
help me >>
I think you want to do following
1) press button on form1
2) in pl sql code of button, open form2 with some parameter
Steps for achiving this
1) in form two in object navigator mode you will file one node called PARAMTERS
add you paratmeter as many you want (for eg. p_1, p_2, p_3)
2) set form 2 in modal mode, so that after before closing form2 user can not access form1
3) in form one pl/sql code of button
pl_name VARCHAR2(10) := 'paramlist';
theformname := 'form2';
pl_id := GET_PARAMETER_LIST(pl_name);
IF ID_NULL(pl_id) THEN
pl_id := CREATE_PARAMETER_LIST(pl_name);
Whoa!! That's too much work!
Use Global Variables...
-- Set your Variable
:Global.Foobar = '42';
-- Call your Form
-- Test or reassign your Variable
:Block.Item = :Global.Foobar;
-- Destroy your Variable
-- Nice and simple!
I got a mysql database "backup" that someone made and I have to use it, trying to get a website back online. Its a Joomla web database. The person ...
I want to fetch invoice data from two tables
table a is in single row and table b data should be multiple rows
single data is fetching correctly but facing ...
I have a datatable in Winforms.
I am currently trying to find the max and min values for each of the columns for each row. My table layout is like ...