I developed one form which having four tabs , i want one button control for all of them , I have been created buttons control individually for each tab , there is problem with navigation , query and clear the form .
View 3 RepliesI just want to ask that can we code number of pages to be printed before printing the report?
Like if we use report builder software of oracle to print a report, this will ask that how many pages you want to print and no of copies you want to make for this report as normally asked with other software before printing.
Actually, I am stuck with a complex query report where every single page has different query to execute. The problem with my report is that when ever user prints the report, the last page comes empty with the page header, no data in it.
What I want is to code, if possible, to print the report avoiding the last page to print. So that every time I can able to control printing pages. For example if report has 10 pages and definitely has data on 9 pages then it can only print up to 9 pages rather than going to print 10 pages.
[save] button can be done but how to handle [cancel] button
Master record
Transaction record 1
Transaction record 2
Transaction record 3the user does one/all of the following changes
Master record
Transaction record 1 : deleted
Transaction record 2
Transaction record 3 :edited
Transaction record 4 :new added
now the Requirement is :
when the user hits [ save ] all the records are saved
with in *new master record ID*
else
when the user hits [ ignore/cancel ] all the *Actions on transaction is rolledback*
I have a tab canvas with 4 tab pages.I want to set scroll bars for each tab page. I draw 4 stack canvas on 4 tab page but it doesn't transferred fields in each tab pages.
View 4 Replies View Relatedhow to display tab pages in line level?
View 1 Replies View Relatedi 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.
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?
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 RelatedI have one interface form where user will choose radio buttons and based on radio button value different report will run, in one radio button i want to check parameters , for example if there are three radio buttons, a - will run a.rdf ,b- will directly run b.rdf , if user chooses c - then prompt will appear asking him to input from date and to date and based on that value c.rdf will run.
I want this date parameters to run only for this report c.rdf only.One way is to display from date and to date on forms and make it applicable to only this report , but i want to use this parameters only while choose c radio button.
I have created a form using data block wizard and lay out wizard. I want to disable the SAVE button, I gave the following in Triggers WHEN-NEW-FORM-INSTANCE
set_item_property('SAVE',visible,property_false);
but when I run the form it displays this message at the bottom of the screen
Frm 41045:Cannot find item invalidID.
I have got a form with 3 buttons and when these are pressed determine who is logged in, what role they are and if they are a certain role go to another block, if they are not that role flag up a message. I think I need to create a function in the database along the lines of -
create function user_has_role (p_user in varchar2 default user, p_role in varchar2)
return boolean
as
select * from dba_role_privs where p_user = GRANTED_ROLE;
end
i'm designing a DB_application where a user makes certain subject selections depending on what grades they have. so far ive made simple signin form as follows....
Create table Persons(
person_id number(8) constraint pk_Persons primary key,
person_pword varchar2(16) not null;
declare
user_id number(8);
user_pword varchar(16);
alert_button number;
begin
[code]...
now the next step... that SIGNED IN user is taken to a menu with links to select their topics or units. HOWEVER only a PARTICULAR link can be followed depending on what grade they've achieved in a NECESSARY UNIT for example to do advanced maths u need beginners maths = PASS. if = fail then user cannot proceed. heres my sql as well as the trigger ive made an attempt at...
Create table Grades(
grade_code number constraint pk_Grades primary key,
grade varchar(4) check (result in ('fail','pass')),
person_id number,
unit_code number,
CONSTRAINT fk_Persons FOREIGN KEY (person_id) REFERENCES Persons (person_id),
[code]...
i know my second trigger is poorly designed and lacking.
I have two data block but i want to execute_query () ; by button when i press the button one data block record display
View 4 Replies View RelatedI have one form where I have let's say 2 items that I want to manage. One is a List Item and the other Text Item. Both are based on one table. The List Item is not updatable (Update Allowed is set to NO) and there I have some types of houses for example (T -> tall house, B -> Big house, S -> Small house it's not important so much) and the Text Item is for counting the types for example we have 4 houses of type T and if we add another one in the textItem we will see 5, so it's not counter for all houses but it counts types of houses and that item is not updatable nor insertable (Update allowed and Insert allowed are set to NO) so it's only purpose is just to show how many hauses we have of particular type and automatically increases the number if we insert new house. Beside this two items I have another Items that conatin some informations about the house (How many flats, doors, windows, and so on..). you've got the picture of my form and table.
Now I want to add one button with trigger WHEN-BUTTON-PRESSED that will do this. If I want to change the type of the house after I inserted it and save it in the table, I have to just change the type in the List Item (choose another type) and press the button to save the same house with the same properties I would say (How many flats, doors, windows, and so on..) but with another type. First when I press the button it must ask me if I am sure that I want to make that change (I'll make an allert fot that) and if I press OK or Yes my house will be saved just with the different type and the previous house with the previous type must be erased. And in the textItem 'the counter', the number of the new type must encrease for one and the previous type must decrease for one.
I hope you understand what I want to do and all I need is that trigger to manage this problem of mine. I know it's possible to do but I am quite new in DB programming and I am not very good with programming in PL/SQL.
I 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 would like to ask a very small question. what is the code that should be written to open a picture inside the button.
I have already made the button, and the trigger is when push button, what I want is when I click the button it opens a picture in this directory:
F:AmjadAmjadamjad1.jpg
the name of the picture is taken from table1 the colum serial_number
My requirement is I have placed a check Box in the Detailed Block and i have assigned values for the check box as
Checked - R
Unchecked - P
Initial Value - R
by default the check box would be displayed as Checked while inserting the values in to table the value of check box is not getting inserted but when the check box is unchecked the the value is getting inserted as P when the submit button is pressed.