Forms :: How To Create Relation Of Two Forms On 6i
Aug 9, 2010when i create the buttons on the master form. if i click the button then open the second form
write us the code on 6i form and this form send to then i see him ok .
ADVERTISEMENT
Forms :: Master Child Relation For Non Control Blocks
Jul 8, 2011I am working on form builder 6i. I have a header block A(Multi record block), child block B. Both are non control blocks. My requirement is, if i put the cursor in any header record, i want to auto populate corresponding child record like in master child relation.
which trigger i need to write logic to auto populate the child record.
Forms :: Master / Detail Relation / Why Populate-details Trigger Not Being Fired
Mar 14, 2013On a form I have 2 blocks, shown on different tabs. Relation created by forms wizard. The relation works great when navigating through the blocks, the details for the master are shown fine.
Example for this form is master block is a type of food. Detail block is list of ingredients.When creating a new type of food, if it's = CAKE we insert records based on a select on another table into the ingredients table.Else, the user has to manually create the ingredients.
Upon commit of the form on master block (must be saved to enable detail block tab), the ingredients are not displayed but are there. If I execute query by hitting F8, the records are present.
Why is the populate-details trigger not being fired or what am I missing?
Forms :: Create View Based On Values Selected In Forms
Jun 7, 2013I am working on a simple form which will get the user to fetch required columns of employee master.
For that i have created a form which will display the column names and select option. When user clicks on query, the form will display the selected columns in a block. After going thru if required the user can download it to excel.
As of now I do not have filtering option. For this I thought of creating view based on the selection and then fetch records from the view and display it in form.
To achieve this I would like to know How I create or replace a view dynamically based on values selected. I remember doing this sort of thing long back, but could not recollect it.
SQL & PL/SQL :: Find Non-relation Table And Relation Table?
Feb 7, 2012Suppose i have to two tables.. emp and dept. Deptno column Foriegn for the both table. how to find the non relation table and relation table.
View 8 Replies View RelatedSQL & PL/SQL :: Relation Between Two Tables?
Dec 28, 2010oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"
I have a main table : CLAIMS_MAIN, in which claim_id is a primary key I have another table : CLAIMS_TRANS , in which claim_id is not a unique key, I mean, there can be more than one records with the same claim_id.. but the column transaction_id is unique, but transaction_id column doesnt exist in the main claims table.
It is required to join both these tables on claim_id...
Forms :: How To Create A Trigger For Age
Apr 16, 2010How do I create a trigger for the age. I want an alert to appear when the date of birth field is less than the age of 17. The formula is age=sysdate-dateofbirth
View 11 Replies View RelatedForms :: How To Create EXE In Oracle
Jul 23, 2013How to Create .exe in Oracle forms
View 3 Replies View RelatedForms :: Create More Than One LOV To Item?
Feb 19, 2011how can i give more than one lov item to an item?
View 3 Replies View RelatedForms :: Create Shortcut Key In 6i?
Apr 25, 2011how can i use "Ctrl+N" key combination for new record using menu bar.
View 1 Replies View RelatedForms :: 11G Frmcmp_batch.sh Does Not Create FMX?
Jul 10, 2012Migrating from 6i to 11gr2 Our forms 11Gr2 and weblogic is running ok on dev workstation. i'm attacking the server. Install was done by admin guys, but they do not know forms.
Had problems compiling so I asked Oracle tech support and they supplied this script. (email them again, but they are not fast...)
for i in `ls *.fmb`
do
echo compiling forms $i...
x=`echo $i | cut -f1 -d"."`
/data01/oracle/app/admin/frdev/bin/frmcmp_batch.sh userid=???/???@???? output_file=/data00/cipo/apps/Creation/staging/$x.fmx batch=yes module=$i module_type=form compile_all=yes window_state=minimize debug=yes
It compiles , no errors but no FMX are created. Did a find everywhere and none are created
compiling libraries does the same thing, no errors but no plx. Menus and report give me an error. (ORA-12154: TNS:could not resolve the connect identifier specified) I can connect via sqlplus on the server and access my db from another server (so tnsnames.ora is fine) the weblogic admin guys compiled the forms also with same results....so i know its not an insufficient unix rights.
How can I setup some sort of in dept log?
SQL & PL/SQL :: Foreign Key - Primary Key Relation
May 2, 2012I am trying to establish PK-FK relationship between 2 tables. Table 1 has VACC_ID as a primary key. Table 2 has VACC_ID and SCH_ID as the primary keys. I am trying to add VACC_ID from Table 2 as a FK to Table 1. This is the code I used
ALTER TABLE Table_1
ADD CONSTRAINT FK_VACC_ID
FOREIGN KEY (VACC_ID)
REFERENCES Table_2(VACC_ID)
I also tried to add it without writing the query and editing the Table 1. By default, I am getting 2 columns(both VACC_ID) in the local column being referenced to the 2 primary keys(VACC_ID and SCH_ID) of table 2. I also uploaded the screeshot of the error, when I run the query.
SQL & PL/SQL :: Update Hierarchical Relation
Nov 13, 2011I have a table which contains the connectivity details. It is telecom data. The table contains the relation between the point features(Ex: Terminal) and linear features(Ex: Cable)
Below is some sample data
drop table connectivity ;
create table connectivity
(
ftr_no number(5),
ftr_id number(5),
[Code]...
-- 2nd linear ftr
insert into connectivity values (30,10359,33, 9655, 2,NULL,NULL);
insert into connectivity values (30,10359,33, 9656, 1,NULL,NULL);
insert into connectivity values (30,10359,30, 10359,3,NULL,NULL);
[Code]...
In the connectivity table PARENT_FTR_NO and PARENT_FTR_ID needs to be updated based on these conditions.
1. Correspponding to each feature there are 3 entries in this table.
2. Each feature(Point orLinear) has 2 sides INcoming and OUTgoing
3. The possible values for the RELATION column are 1, 2 and 3 where
-> 1 indicates feature conncted at the OUTgoing end
->2 indicates features connected at the INcoming end
->3 indicates self connected
4. Always a linear feature is the parent of a point feature which are connected to the OUTgoing end of the linear feature (i.e where RELATION = 1)
There is another table which contains FEATURE_NO and FEATURE_TYPE.
create table ftr_catgry
(
ftr_no number(5),
ftr_type char(1)
);
[Code]...
FTR_NO F
---------- -
33 P
31 L
30 L
Where
'L' represents linear feature
'P' represents point feature
The relation should be updated as
Step 1. Start with a linear feature, for example FTR_NO = 31
SQL> select * from connectivity where ftr_no = 31 and ftr_id = 10354 and relation = 1;
FTR_NO FTR_ID CONNECTED_FTR_NO CONNECTED_FTR_ID RELATION PARENT_FTR_NO PARENT_FTR_ID
---------- ---------- ---------------- ---------------- ---------- ------------- -------------
31 10354 33 9651 1
The feature connected to the OUTend of the 10354 i 9651 with FTR_NO = 33 and it is a point feature so the parent for 9651 is 10354
Step 2.
SQL> select * from connectivity where ftr_no = 33 and ftr_id = 9651 and relation = 1;
FTR_NO FTR_ID CONNECTED_FTR_NO CONNECTED_FTR_ID RELATION PARENT_FTR_NO PARENT_FTR_ID
---------- ---------- ---------------- ---------------- ---------- ------------- -------------
33 9651 33 9652 1
9652 is connected to 9651 at the OUTend, since 9651 is point feature so the parent of 9651 which is a linear feature is also the parent for 9652
Likewise the all relations have to be updated
Expected result after update
SQL> select * from connectivity;
FTR_NO FTR_ID CONNECTED_FTR_NO CONNECTED_FTR_ID RELATION PARENT_FTR_NO PARENT_FTR_ID
---------- ---------- ---------------- ---------------- ---------- ------------- -------------
31 10354 33 9650 2
31 10354 33 9651 13110354
31 10354 33 10354 3
33 9651 31 10354 2
33 9651 33 9652 13110354
33 9651 33 9651 3
33 9652 33 9651 2
[Code]...
24 rows selected.
SQL & PL/SQL :: Parent Child Relation
Sep 17, 2013I have one requirment like below
Table1 have records like below
parent childflag
null.....A......Y
A........B......Y
B........C
C........D
D........E......Y
I want it should be like
parent child flag
null......A.....Y
A.........B.....Y
B.........E.....Y
I want to replace 'D' (parent of 'E') with any of the upper level which has Flag 'Y' (first level parent which satisfy falg 'Y')
Forms :: Create Login Form In 10g?
Jun 17, 2011how to create a login form in forms 10g how upload login.fmb
View 2 Replies View RelatedForms :: Where To Create Database Link
Jun 18, 2013Usually where should we create the database link? In the production or development? create public database link dblinkname connect to user_in_db2 identified by password_in_db2 using 'tnsentry name in db2'; In production or development?
View 2 Replies View RelatedForms :: How To Create Trigger On Backend
Oct 14, 2010I Created a form just for testing purpose [Which is i attached]
My Table is TEST0
Structure of table :
---------------------------
NOVARCHAR2(5)
NAME VARCHAR2(10)
FLG VARCHAR2(1)
My Task is When i added a record, e.g if on form, i add name - AAD But its must save on TEST0 Table like this way EMPAAD...means always concate with 'EMP'||:Block.name while saving on database..
I know how to do with front end application, but i want to achieve this task by using trigger on backend databse...how to create a Trigger on backend....i try a one trigger but it give me error- Unable to insert Record...
Forms :: How To Create Multiple Go_blocks
Apr 16, 2010how do I create multiple go_blocks
View 3 Replies View RelatedForms :: Create A Form For Ordering
May 25, 2010i create a form for ordering>>>that the person can enter his/her information and isbn book to make the order,but the order id i make it sequentially! well first of all i create a data-block and i insert only the oid in trigger when-new-item-instance..i had create the sequence:
declare
create sequence seq1
start with 90
increment by 10;
end;
and i make a view form such of fields that user can enter a details o what he/she want to order!!
1- is that enough?
2- it seems there is an error in creating the sequence?? wrong way to create the sequence!!
Forms :: How To Create Login Form
Oct 23, 2013I have made few forms , but i want only those users to access these forms who have valid login and password to access these forms.
For example i have created one form employee details (shows the details of emp table in tabular form) which is based on emp table.
The users are scott having password tiger ,and User Test having password Test. i want to make a login form to give access to only these users to access employee tables. if someone else tries to access it then it should show Unauthorized login error.
My requirement is i want to create a basic login form which includes
Login i.e Text_item
Password i.e text_item
Login i.e push button
what should be the queries behind these items. and how to connect this form to database. I am attaching file , just add working codes in that or you can write codes here also .
Forms :: 11g - Create Data Block?
Jul 6, 2010I m using Forms 11g. when I m trying to create Data Block & Select table Name then I received the following error.
View 5 Replies View RelatedForms :: Create Unique Primary Key
Nov 28, 2010A Master form in a tabular format. Id is a display item. I want to auto generate Id with following query.
select nvl(max(issue_id),0)+1 into :issue_mt.issue_id from issue_mt;
It works:
1)When each record is saved before creating new record.
It doesn't work:
2)If multiple records are entered with out saving each record.
What to do to generate unique Id in both cases?
Forms :: How To Create Multilingual Form
Feb 4, 2011My requirement is to create Multilingual form. Its very urgent. In fact if i want to make it work in 2 languages. English and Chinese.
View 1 Replies View RelatedForms :: How To Create LOV Via Own Mother Language
Apr 28, 2011I am using Developer 6i and oracle 8i. when we r create LOV , it's generate by English language. and it's contains 3 button . this r find, ok , cancel button. but now i want this 3 button language show by my mother language(Bangla language). it's possible
View 1 Replies View RelatedForms :: How To Create Stopwatch In Oracle 6i
Apr 11, 2011i need to create stopwatch in oracle form 6i, i need source code or the form.
View 1 Replies View RelatedForms :: How To Create Tree Structure In 6i
Apr 5, 2011I want to know how to create tree structure in forms6i. This should be created as " Control-block". For example when user expand department it shows all department names in college as sub tree. Note: I have no table for department..Just display manually..
View 1 Replies View RelatedForms :: How To Create Icon Menu
May 29, 2010I want to create icon menu.
It fails to upload the images (newrec, saverec, delrec, etc) even the path is given in ICON_FILE_NAME.
Forms :: How To Create Calendar In Oracle
Aug 29, 2012I desire to create pick my date of birth from the calendar. So I have done this. I am using oracle 6i Form developer. I have not find files 'standard' and 'calendar.pll' files anywhere.
View 1 Replies View RelatedForms :: 6i (FORMS_DDL Used To Create A Function)
Sep 8, 2011I am using a form which create function to calculate value using form_ddl. When I used this program from superuser it will calculate correct value but in other user it calculate wrong value. I gave 'Create Procedure ' privilege to user too.But still problem exist.
View 3 Replies View RelatedForms :: How To Create Sequence In Form
Jan 13, 2013I know how to create sequence in the database.But I want to create this sequence from the form by giving the name of the sequence from a filed in the form.
View 1 Replies View Related