Migrating 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.
I 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.
How 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
Usually 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?
I 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...
i 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!!
I 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
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 .
I 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
I 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..
I 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.
I 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.
I 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.
I have created one form with control block and database data block.here i have created one save button based on that i have to save records both control and database block in database block table.If i i write commit_form record will be saved on different rows in a table means control block record in one row and datablock record in one row.But i want to update in one row(one line) in a table.
I know how to design master_detail form using wizard but i want to create it without using wizard.I have created two blocks emp and dept without using wizard ,and connected them to emp and dept table by changing their properties.Now i want to create relationship between these two blocks, My requirement is when i press execute_query button if deptno is 10 in dept block then emp block should show data for deptno 10 only.
I know it can be done using add relationhip option in dept block (which is master block)but how to do that.
