Forms :: Create Shortcut Key In 6i?
Apr 25, 2011how can i use "Ctrl+N" key combination for new record using menu bar.
View 1 Replieshow can i use "Ctrl+N" key combination for new record using menu bar.
View 1 RepliesThe way to create a short cut on desktop to have an sql*plus (command line).
i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut-I would provide the database name, username and password)
IF on button label, we use ampercent "&" to make its shortcut then is there anyway to make a shortcut for TEXT BOX ITEM ?
View 4 Replies View RelatedI have a problem with getting '|' sign in TOAD Editor. It is default for Croatian keyboard layout that I get '|' sign when I press Alt_gr+W key combination.
But in Toad, when I press Alt_gr+W combination Watches dialog is opened.I want to get '|' sign in Toad Editor when I press Alt_gr+W.
Is there a shortcut to get the Select Connection Dialog box in SQL Developer?
Every time I need to execute a Query I have to use the mouse to change the Connection, if there is any Shortcut then that would be easier for me to wotk with.
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.
when 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 .
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
View 11 Replies View RelatedHow to Create .exe in Oracle forms
View 3 Replies View Relatedhow can i give more than one lov item to an item?
View 3 Replies View RelatedMigrating 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?
how to create a login form in forms 10g how upload login.fmb
View 2 Replies View RelatedUsually 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 RelatedI 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...
how do I create multiple go_blocks
View 3 Replies View Relatedi 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
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 .
I 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 RelatedA 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?
My 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 RelatedI 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 Relatedi need to create stopwatch in oracle form 6i, i need source code or the form.
View 1 Replies View RelatedI 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 RelatedI want to create icon menu.
It fails to upload the images (newrec, saverec, delrec, etc) even the path is given in ICON_FILE_NAME.
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.
View 1 Replies View RelatedI 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 RelatedI 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 RelatedCan We Create Forms Runtime in Oracle Forms 10g Like Oracle Forms 6i
View 1 Replies View RelatedI 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.
View 2 Replies View RelatedHow can be create temporary objects through forms 10g?
In oracle we can create a temporary table so similarly by using forms_ddl can we create a temporary table?
Are there any other temporary objects?