Forms :: Dynamic Table In Form
Dec 22, 2011create a table in forms .
i tried to do it with forms_table(--) but i am in confusion.
ADVERTISEMENT
Forms :: Dynamic Form According To Rows In Another Table?
Oct 28, 2010 i want to create a form & show some columns accordingly rows entered in another table
for eg.
a table name temp have three columns (no,name,date) in name it shows some rows like
a
b
c
d
i want to create a new dummy form which shows
a b c d
if i remove b from temp table then new form shows only
a c d
is it possible
Forms :: Dynamic List From One Table And Insert Into Another?
Jan 10, 2013Im facing some issues with my form, getting stuck... prob desc below : I have Table A which has columns; car_year, car_type, line_num, line_text. Table B has country, car_year, car_type, line_num, data_entry_amt.
Table A contains data which gets updated once every year only. Contains what year model is the car, what type of car it is.. Line_num has numbers starting from 1 which indicates the different part number and line_text has description for that line_num. eg :
2010 Toyota 1 Windshield
2010 Toyota 2 Door
2010 Toyota 3 Tire
2010 BMW 1 Windshield
2010 BMW 2 Door
2010 BMW 3 Tire
2010 BMW 4 Rear_mirror
Table B contains specific data related to table A, Contains country where car details n prices are, car_year, car_type, line_num, and amount($) for that part. for example :
Australia 2010 Toyota 1 400.50
Australia 2010 Toyota 2 200.40
Australia 2010 Toyota 3 308.25
So in year 2010, in Australia, Toyota's Door was sold at $200.40 Now, Table A will have similar data for this year and users will enter data for table B throughout this year. I tried master-detail form for this but it doesnt work. Because every year line_num change in table A and therefore cant implement a fixed number or rows on the form for amount for table B.
How to use dynamic listing but im not familiar with it. So how i should go about doing this. My form has structure has below :
Country Car_year
___________________________________________________
table_A.line_num table_A.line_text table_B.data_entry_amt
table_A.line_num table_A.line_text table_B.data_entry_amt
table_A.line_num table_A.line_text table_B.data_entry_amt
table_A.line_num table_A.line_text table_B.data_entry_amt
When clicked on save, data on table_B.data_entry_amt on this form should go n insert into table B.
Application Express :: Dynamic Tabular Form
Jul 9, 2012I have one table that holds a list of People...
Another that holds Classifications
Another that holds Sub Classifications (linked to the Classification table)
Table(*Person*)
PersonID, PersonName
Table(*Classifications*)
ClassID, ClassName
Table(*SubClass*)
SubClassID, SubClassName
I need a form that will allow me to put Classifications and Sub Classifications against a Person. I want to be able to add new Classifications and SubClass Values which are dynamical added to the form...
I have a table that holds other data and links the People to the Assessment
Table(*Person2Assessment*)
AssessmentID, PersonID, Date, AssessorName, Notes
I have a table to hold the Values of the Assessment...
Table(*AssessmentValues*)
AValuesID, AssessmentID, ClassID, SubClassID
-----------------------------------------------------------------
A typical person may look like:
e.g.
Person1(Fred)
Class1(Programming C++)
SubClass1a(Expert)
Class2(Language)
SunClass2a(English-speaking)
Class3(Location)
SubClass3e(India)
-----------------------------------------------------------------
Now I have the data tables but how to create the table and save the values for the Assessment Values in one table the dynamically adds values based on the different classifications available...
Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW
Apr 17, 2012I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
Application Express :: Deleting From A Tabular Form With Dynamic Action
Jan 24, 2013Using Apex 4.2
Is it possible to delete a row from a tabular form using dynamic actions.
At the moment my report sql contains html and javasript for a delete button
'<input type="button" name="Delete" value="Delete" onclick="del(''delete'','''||a.applicationname||''')">' A2I then have javascript in my page header
function del(Request, Name){
var answer=confirm("Do you really want delete application "+Name+"?
* Provider assignments will be deleted
* Application objects will be deleted
* DB-roles will be dropped
* DB-views will be dropped
* User-synonyms will be dropped");
if (answer==true) {
document.getElementById('P10_APPLICATIONNAME').value = Name;
doSubmit(Request);
}
}
Finally I have a page process to do the delete which fires when the request = delete
Application Express :: Dynamic Action For A Text Field In Tabular Form?
Sep 13, 2012for a text field of a, wizzard generated, tabular form i created a dynamic action when lost focus. using a jquery selector to bind the da to the item in every row when the event fires some jscript and pl/sql code is executed. this all works like charm for existing rows.
but how can i bind the da to the field for newly added rows?a sc of the definition of the da can be found here [URL]...
Forms :: Updating Value Of Table From Textbox Which Is On Form
Oct 30, 2013i m doin simple application, in which all data is retrieving from table in to form(all the
field are textbox and button on form) ename,dept,salary,dept_id etc.
i took one textbox field on form which is non table field
(no db field bt linked to another table..via LOV m retrieving value into this textbox which suppose dept_id ) and now after selecting one record from list box into textbox which is non table field.... after immdiately selecting i want to update one field into db field which all other form field contains...
so how to do this??which trigger i hav to use for this?
if :dept_id is not null then
begin
update dept
set loc =:emp.loc
where dept_id = :emp.dept_id;
forms_ddl('commit');
exception
when others then
null;
end;
end if;
it giving error.......if m using commit in this...i hav used post query trigger ...is dere
any other trigger hav to use
Application Express :: Dynamic Action In Report Region In Master Detail Form
Nov 7, 2013I have created a master detail form , in which many validation etc is done ,the MASTER is a FORM and DETAIL is a REPORTNow I am stuck up with the detail region .i.e reportI have Line Detail where there are ITEMS such as SL NO:
,ITEM_ID , UOM ( Unit of measuremnt ) etcNow here is where
Using POP UP LOV i have managed to fetch in LOV for the item "ITEM_ID",---
i can select an item name using the pop up LOV ,Now all that I want is when I select an item name from the pop up lov , an Item Id is displayed or fetched in that particular place , now i want the corresponding UOM to be diaplayed ( i.e the UOM for that particular Item Id which has been selected by me from the pop up lov ).
In order to resolve this I created a Dynamic action where in I get the UOM . Bt the problem is that the ITEMS displayed for selecting in the WHEN section (DYNAMIC action-IDENTIFICATION section-WHEN section----- items ( here i am not listed with ITEMS of the REPORT region instead ITEMS of the MASTER is available )-TRUE ACTION section etc is only theITEMS of the MASTER region ..
Forms :: Inserting Multiple Records In Table Through Tabular Form
Apr 1, 2012i have a master-detail form.
detail block is tabular.
when-button-pressed trigger iam inserting records in another table.i write
insert into ONHAND_QTY_LOCATION(sno,matid,matcode,description,partno,onhand_qty,location)
values (:ship_dtl.slno,
:ship_dtl.mat_id,
:ship_dtl.mat_code,
:ship_dtl.description,
:ship_dtl.part_no,
:ship_dtl.rec_qty,
:ship_mstr.place_from)
it is inserting only one record in onhand_qty_location table that too the last record.
i want all the records which iam entering in detail block should get entered in onhand_qty_location table.
Forms :: Displaying Records From A Table In Tabular Form With One Condition?
Mar 17, 2012i want to display records from a table in tabular form with one condition.
i made a tabular form.and in WHEN-NEW-FORM-INSTANCE i write
DECLARE
CURSOR hascr IS
SELECT
BILL_ID,
BILL_DATE,
MAT_CODE,
PLACE_FROM,
[code]....
when i run the form its not showing any errors but displaying only one record.that is the first record whose bill_type is send to other store.
am i using the right trigger or my select statement has problem?
Forms :: How To Find Table Names For The Fields In A Horizontal Form Of ASCP
Jun 25, 2013I have a requirement of pulling the data from a field in horizontal form of Advanced Supply Chain Planning responsibility(ASCP). When I go into help-> Diagnostics, it shows the block name of the form as 'Horizontal Plan' and field name as 'Pivot Table'. Not pretty sure on how to pull the data source into horizontal form with the info I have.
View 3 Replies View RelatedForms :: Setup Form And Database Table For Time Entry Only (exclude Date)?
Feb 19, 2010I have a form that the user has to enter a time of an event.
The time entered will most likely be in the past and NOT the current time.
What is the best way to set up a form and a database table for time entry only (exclude the date)?
I have tried datetime on the form with format HH12:MM PM and date on the database.
I have also tried the same with a timestamp on the database.
The time always appears to get entered correctly. However, the time is always stored as AM regardless of what is specified by the user.
Forms :: Opening Form Has Attached Libraries Caused Form Close
Jul 19, 2010If I open a form has attached libraries in form builder on windows7 it closed and give this message :
Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll
[code]......
Forms :: Want To Call Web Form For Uploading Image From Custom Form
Apr 16, 2013I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.
View 1 Replies View RelatedForms :: How To Reload Calling Form After Closing Called Form
Jul 15, 2007I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.
How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?
Forms :: 2 Different Form To Pass Values From One Form To Another
Mar 11, 2010is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.
View 1 Replies View RelatedSQL & PL/SQL :: Dynamic Function - Create Physical Table And Return Table Name In Out Variable
Aug 30, 2011I am trying to execute dynamic SQL in Stored Function and I don't know how to do this.
Explanation:
In the function I am calling pr_createtab is procedure which will create a physical table and return the table name in the out variable v_tbl_nm.
I need to query on this dynamic table and return the result as return result. But i am not able to do it.
Here T_web_loylty_report_table is a type.
CREATE OR REPLACE function CDW_DSS.f_ReturnTable(i_mrkt_id in number, i_cmpgn_year in number)
return T_web_loylty_report_table is
v_tbl_nm varchar2(50);
i_cntry_cd varchar2(20);
v_sql_str varchar2(32567);
[code]......
Forms :: First Form Clear Previous Data And Then Populate Data From Table
May 7, 2012when i press when button pressed trigger, i want first the form will delete all the previous data and then populate the data from the table, that's why i used clear_block first, but this clear_code is not working here. my coding is given below
go_block('show');
clear_block(NO_VALIDATE);
declare
cursor c1 is select *
from qtr_demand order by 1;
begin
[code]..........
Forms :: Any Way To Load A Form Within A Form
May 21, 2010I have a requirement, is there any way i can achieve the following User Interface using oracle forms
Left Pane: Navigation (Tree Menu)
Right Pane: Based on the node clicked in the Tree Menu, a specific form will be loaded on the right.
The tricky part, is there any way i could load a form within a form ? If i make use of OPEN_FORM, it will open a form in its own window.
Forms :: How To Open Another Form Within A Form
Dec 20, 2012I want to convert my forms6i application into forms9i therefore I initially converted my login and explorer form.
In my login form, I am using NEW_FORM to close my login form and wants to activate my explorer form but every time a pop-up raised and asked "DO YOU WANT TO CALL THE NEW FORM?", if I pressed YES then pointer moved to explorer form.
This form is working perfectly in 6i and didn't asked anything and moved to successfully to explorer form.
Forms :: Pre-form And When-new-form-instance?
Mar 1, 2010What is the difference and significance of
1) Pre-form and When-new-form-instance?
2) Post-text-item and When-validate-item?
SQL & PL/SQL :: SELECT From Dynamic Table Name?
Jul 12, 2013I do not know the table name but have a query that for sure returns the table name and I want to select a column value from the table into my PLSQL variable.
Here is the code :
DECLARE
v_VerTabName VARCHAR2(30);
v_Minor NUMBER(2);
[Code]....
But when I compile this I get ORA-00936 : Missing expression at the EXECUTE IMMEDIATE line.
PL/SQL :: Insert Dynamic Table
Nov 9, 2012Oracle 11.2
I trying to create a procedure that could update one or more different table into clob data - but only those tables that contain your search (indexed) word.
I have a 3 tables: item, common_lookup, member
>
CREATE INDEX i_item_barcode ON item (item_barcode) INDEXTYPE IS ctxsys.context;
CREATE INDEX i_item_title ON item (item_title) INDEXTYPE IS ctxsys.context;
CREATE INDEX i_item_subtitle ON item (item_subtitle) INDEXTYPE IS ctxsys.context;
CREATE INDEX i_common_lookup_meaning ON common_lookup (common_lookup_meaning) INDEXTYPE IS ctxsys.context;
CREATE INDEX i_account_number ON member (account_number) INDEXTYPE IS ctxsys.context;
[Code]....
Now is the question.. If it possible to create the procedure search_execute which can add data depending on subbmited parameters ?
If it possible, can You give me an example (dbms_output/update_clob), for search_execute to recive something like that:
>
search_execute ('Wars', item, item_title)
>
>
select * from clob data :
1 1068 ASIN: B00003CX5P 1014 Star Wars - Episode I The Phantom Menace (CLOB) (BLOB) PG MPAA 22-mar-2005 3 16-lut-2012 17:31:55 3 16-lut-2012 17:31:55
2 1069 ASIN: B00006HBUJ 1014 Star Wars - Episode II Attack of the Clones (CLOB) (BLOB) PG MPAA 22-mar-2005 3 16-lut-
[Code]....
I try write something like this (it is not compile - and I know where is mistake, I tried to figure it out in several different ways - This is just my way of thinking expression) :
>
CREATE OR REPLACE PROCEDURE search_execute (v_text IN VARCHAR2, v_column_name IN VARCHAR2, v_table_name IN VARCHAR2)
IS
v_clob CLOB;
v_tmp_clob CLOB;
CURSOR c1 IS (SELECT * FROM v_table_name WHERE contains (v_column_name, v_text) > 0);
CURSOR c2 IS (SELECT column_name FROM user_tab_cols WHERE table_name = v_table_name);
BEGIN
[Code]...
SQL & PL/SQL :: Dynamic Table Creation Using Timestamps?
Nov 28, 2010I have a requirement to create the table monthly.The tablename will be the o/p of the following select query.
select 'TBR_AND_SECURITY_DEPOSIT'||TO_CHAR(sysdate, 'Monyy') from dual
I am trying to create the table for creating the backup of the existing table TBR_AND_SECURITY_DEPOSIT.
create table (select 'TBR_AND_SECURITY_DEPOSIT'||TO_CHAR(sysdate, 'Monyy') from dual) select * from TBR_AND_SECURITY_DEPOSIT
but it is throwing error as invalid table name.
SQL & PL/SQL :: Dynamic Create And Populate Table
Jan 27, 2012I am dynamically creating a staging table my_stg, and then populate it. Seems simple, but not sure why i get this error,
create table gtest4(myid varchar2(10), mykey varchar2(10));
create table gtest5(myid varchar2(10), mykey varchar2(10));
insert into gtest4 values(1,3);
insert into gtest4 values(2,7);
insert into gtest5 values(5,3);
insert into gtest5 values (1,7);
commit;
CREATE OR REPLACE PROCEDURE px
IS
TYPE rectype IS RECORD (
myid VARCHAR2 (100),
mykey VARCHAR2 (100)
);
TYPE tabtype1 IS TABLE OF varchar2(100)
INDEX BY BINARY_INTEGER;
TYPE tabtype2 IS TABLE OF varchar2(100)
INDEX BY BINARY_INTEGER;
rec1 tabtype1;
rec2 tabtype2;
cur sys_refcursor;
[code]....
count current exists max min prior sql stddev sum varianc execute forall merge time timestamp interval date
pipe
<an alternatively-quoted string literal
SQL & PL/SQL :: How To Get Dynamic Columns Using Default EMP Table
Aug 18, 2011i am practicing to get Dynamic columns as i have learnt from Orafaq SQL/PLSQL forum .i am using Default EMP table...first one is running smoothly as below:
1 DECLARE
2 v_sql VARCHAR2(32767);
3 v_refcur SYS_REFCURSOR;
4 BEGIN
5 v_sql := 'SELECT deptno ';
[code]....
Application Express :: Insert Into History Table When Update Action Is Performed On Tabular Form View Or Table
Aug 24, 2013My scenario is I need to insert into History table when a record is been updated into a tabular form(insert the updated record along with the additional columns Action_by,Action_type(Like Update or delete) and Action Date Into History table i.e History table contains all the records as the main table which is been visible in tabular form along with these additional columns ...Action_by,action_type and action_date.
So now i dont want to create a befor/after update trigger on base table rather i would like to create a generic procedure which will insert the updated record into history table taking the page alias and pade ID as the parameters(GENERIC procedure is nothing but whcih applies to all the tabular forms(Tables) contained int he application ).
Forms :: How To Set Dynamic Path In 6i
Aug 6, 2008I am using Oracle Form 6i. I have created pdf file from oracle report. On view button, I have written:
host('C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe C:dailypending.pdf');
I don't want to set this path on every machine. I want to set its dynamic path so that on which even I machine, I run the applicaiton, it will directly find AcroRd32.exe from any drive either C: or D: or anything else...
It might be Acrobat Reader 9.0 or 8.0 whatever version will be installed on client machine...I want to set path according to that..So that whatever version it would be, it doesnt affect the application..
Forms :: Display Dynamic LOV?
Aug 28, 2007 I want to create dynamic Lov. How can I create it? For practice I create a LOV at design time
RECORD_GROUP_QUERY value:
SELECT * FROM
EMP.
THEN I write some code in WHEN-BUTTON-PRESSED Trigger to replace RECORD_GROUP_QUERY at run time. Code is:
........
v_rg_id:=CREATE_GROUP_FROM_QUERY('TEST','SELECT * FROM DEPT');
........
After this I found a error at run time which is FRM-41826: Cannot replace group; columns don't match LOV.