I want to change the color of push button & give a label to it in form 6i..
For that I change the iconic property to yes and then change the color of push button but by this the label get disappeared.
I have a data block in which I am displaying 15 records at a time. The query for the block is complex with 3 tables and multiple joins. There is no primary key associated with each record, but I'm storing rowid in a hidden field. I have a push button in each row/ record. When user double clicks on it, I want to get the rowid in the record and pass it to pl/sql.
Also there is one column in table which is stored as char (ex, Y/N) but when I display in the table it should be Yes/ No. How to achieve this?
How can we run concurrent program on SAVE (push button) in oracle forms?
View 3 Replies View RelatedI am trying to put iconic image to the button.
I put the properties to the button
Label : Clear
Iconic: yes
Iconic file name: clear.
after that it is not showing the Label to the Button. It is showing only the iconic image only.
I am working on forms 10g(version 10.1.2.0.2 ) with Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 on windows 2000 platform. My requirement is to dynamically get the label of the radio button item in a radio group.I am able to get the label of the radio group as shown below
Item :Radio group
Label : Gender
IF m_type = 'RADIO GROUP' THEN
m_label:=Get_Item_Property(m_Item ,label);
END IF;
There two Radio buttons inside this radio group which are
item : Radio button
Label : Male
item :Radio button
Label :female
What is the code to get the label of radio button(i.e) male and female ?
How will I get the count of radio buttons in a radio group at runtime?
how to display check box selected records in one column of form when push button is pressed.
View 1 Replies View RelatedMy VNC Hangs after completing all the steps in dbca while installing 11.2.0.3.0 after giving finish button to install database.
Completed All software installation.
Red Hat version: Red Hat Enterprise Linux Server release 6.2 (Santiago)
Linux xxxxxxx.xxxxx.net 2.6.32-220.el6.x86_64 #1 SMP Wed Dec 7 10:41:06 EST 2011 x86_64 x86_64 x86_64 GNU/Linux
I have set up a label which interacts with our LIMS system. I have set up variables on this label which pull in attribute values from the available tokens. When the attribute value is null, the label is automatically inserting 'N/V' onto the label.
I would prefer for the variable to appear as a blank field on the label when the attribute value is null in the LIMS. can't find anything in the user's manual. Perhaps there is some setting where you can define what to display for null values. I can't seem to find any information on this.
I want to know about that is it possible to change the default label that i.e. "oracle As form service" after run a form.
View 4 Replies View RelatedHow to get the label (not value) of current selection in a List Item.
View 7 Replies View Relatedi'm not able to open layout in the custom form.automatically it will be closing and giving this error. Oracle Forms Designer has encountered a problem and needs to close.
View 5 Replies View RelatedI want to move data between two instances and recommended we create a local database link to PULL data from remote database located here (supplier on site) but they want to PUSH data to us. I thought you could only PULL data over a database link but then read the link [URL] where PUSH is considered ? I was going to use standard creatas like create table A as select * from table A@<remote_db_link> which works well and fast ( tried and tested) but some are saying they think PUSH quicker/better ?
we do have data "PUSH" already but this does not use a db link - effectively it calls a local proceedure here and passes a row of data and is slow ie for a 1000 row table to be pushed to us we have our local proceedure called 1000 times.
I have always suggested a PULL with db_link as the fastest method - any proof OR info on a fast PUSH method ( that is quicker than PULL ) ? can you REALLY push ?
I have problem with my Replication using oracle 9i.It does not push transactions automatically when refresh time comes but it works fine when pushed manually.I have two sites:
1- Master
a-Master group
2- Materialized view site
a- Materialized view group (Asynchronous)
b- Materialized view with refresh occur automatically on future date every 5 minutes
c- refresh type FORCE.
I have a requirement. I will get .csv files . I need to extract the data from .csv file and push into the various tables.
The illegal data will be rejected and sent back to the sender.I need to schedule this logic every weekend. I am on 10gR2 on Solaris.
I have a multimaster advance replication environment and we have less than 10 transaction per day...I want to propagate data as soon as possible like sync if I setup the schedule push to propagate transaction every 5 seconds as below
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH(
destination => 'orc2',
interval => 'SYSDATE + (5/60*60*24)',
next_date => SYSDATE,
parallelism => 1,
delay_seconds => 10);
END;
/
in other hand ,book(I mean Advance Replication) has written that for simulating continuous push we should setup it as below so it will propagate transaction every 1 minute.
My second question is:I know interval >= 'SYSDATE + (1/144)' means every 10 minutes a job will start and delay_seconds => 1200 means each job remain aware for 20 minutes, but I can't understand the logic?why it can simulate 1 minute propagation?
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH(
destination => 'orc2',
interval => 'SYSDATE + (1/144)',
next_date => SYSDATE,
parallelism => 1,
execution_second >= 1500,
delay_seconds => 1200);
END;
My thrid question is :Which of the above setups is a better solution for my environment?
i want do add a image as a button.i added iconic image on a button from desktop,but its not working during runtime,i only see a flat button instead of iconic..what should i do...??
View 2 Replies View RelatedI hava LOV and i want process events when click button Cancle on LOV then disable a canvas, but i don't know how process it.where could know events click mouse in button Cancle on LOV - Oracle Forms?
View 9 Replies View RelatedIs it possible to add some custom image on a button?
If so, How to do it?
I try to apply update statement on the button for the specific records, the command does executes if in the end i write execute_query it always asks for do u wanna save the records, yes or no. I want to remove that message. Also if i write commit it does remove that message but everytime i press the button it updates the old record fine but also adds one more entry for the same record.
View 5 Replies View RelatedI am working on form 6i. I want to disable the 'SAVE' button which can be seen in the menu (front end).
View 2 Replies View RelatedWithout using any templates, i created a customized sample form....now i want to add data thru that form....i dont know where to write code and what is code if i want to add data?
View 9 Replies View Relateddeclare
blk_name varchar2(60);
form_name varchar2(60);
[Code].....
this is my coding on save button. this is working fine but only once. when i enter the data second time and try to save, it didn't do anything. what should i do?
I currently have a form and when I am logged in as the owner the execute query button can be performed. But when I try and do this with another user the query cannot be executed. I have granted the users with the correct privileges. I am now trying to re-create the data block but with using the synonym but the synonyms cannot be found.
View 8 Replies View RelatedWe have a Form for viewing some datas, now i need to create a new button and Hide that button while run time for All Users except one user, how to set this option.
Addl.info: This Button should be displayed only for a single user login not for all the users using that form. how to make this option?
I have a question related to margins in button labels. Is it possible to change left / right or top/bottom margin space in that kind of elements ?
View 1 Replies View RelatedI have a master-detail form on which i have 2 buttons. save button and another location button in detail.on location button i am calling a form and updating location of the material entered in detail(tabular).
The thing is my form should not get save without updating location for each record entered in detail(tabular).if user try to save form without updating or pressing location button it should give message PLEASE UPDATE YOUR LOCATION.
my problem is with cancel masterbutton, when i clear form through this cancel masterbutton it clear the form. but after this when i click on show button it is not working, although show button is working correctly before pressing cancel_query masterbutton. what should i consider for correct working.
View 3 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 RelatedI have some doubts about Radio buttons,
1) how to validate radio buttons in WHEN-RADIO-CHANGED?
2) how to disable a radio button?
3) how to disable a text item when a radio button is un-checked.
4) how to assign default value to radio button like(1,2,3...) or(A,B,CD,...)
which is the trigger that fires when we Press the Standard 'Save' button from the toolbar? And i want to update the record on another table which is not in data block by using this save button? @ that time i want to display message like transaction complete:1 records saved..how to do this?
View 24 Replies View Related