Forms :: Button Pressed Trigger

Jan 6, 2012

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

View 16 Replies


ADVERTISEMENT

Forms :: How To Skip Trigger Only When Button Is Pressed

Mar 9, 2013

in my form I have a button that updates a table and I have a pre-update trigger.

is it possible to skip the pre-update trigger only when the button is pressed.

View 2 Replies View Related

Forms :: Any Method On WHEN-BUTTON-PRESSED Trigger

May 9, 2012

I have a form of a user feedback with SMS Sending. which I gave to my all clients when ever my any client enter a feedback they press send SMS button so I got SMS if they press the button 2 times I got 2 same sms and if press the button 3 times I got 3 same sms and so on I want to restrict them and allow them to send only 2 sms of that feedback.any method on WHEN-BUTTON-PRESSED Trigger.

View 7 Replies View Related

Forms :: ORA-305500 Exception On When-Button-Pressed Trigger?

Jun 20, 2005

why this exception is occuring .my code is below.

Procedure Edit_File
(v_linked_file in out file_link.linked_file%type,
v_copy_status in out file_link.copy_status%type,
i_ext in varchar2) is

[code]....

View 18 Replies View Related

Forms :: How To Copy Values From One Table To Another Using When-Button-Pressed Trigger

Feb 14, 2013

I have two tables one is

1)create table abc(c_name varchar2(10),c_number number(6),c_loc varchar2(8)); --having values
2)create table temp(sname varchar2(10),sid number(4),address varchar2(10));---no having

and my question is how to insert a values into temp using when-button-pressed trigger based on abc table in oracle form.

View 16 Replies View Related

Forms :: FRM-40735 / WHEN-BUTTON-PRESSED Trigger Raised Unhandled Exception

Aug 17, 2011

I have a form which contains tabular layout which i can fill a text item with date format. I set the data type properties to "Date" with format mask "dd-mm-yyyy".When I click a "save" button, it will call a procedure to insert into table. But i'm getting this error message : "FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502"

I did some search on google and error 06502 means numeric or value error. But I don't understand what caused my error. Is it at my text item's properties?

View 5 Replies View Related

Forms :: FRM-40735 When Button Pressed Trigger Raised Unhandled Exception ORA-01843

Oct 30, 2013

I am trying to insert some values into a table from a form i get the below error;

which says not a valid month;

FRM-40735 WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-01843

after i do google i added the below one to the insert statement and again i receive the error;

to_date(to_char(sysdate,'dd/mm/yyyy'),'dd/mm/yyyy')

My Insert Statement

insert into Invoice123
(Invoiceno, invdate, gross_tot, discount)
values
(nvl(INVOICEno(j),0),
to_date(to_char(invdate(j),'dd/mm/yyyy'),'dd/mm/yyyy'));
commit;

by which format we can achieve this!

View 6 Replies View Related

Forms :: FRM-40735 / WHEN-BUTTON-PRESSED Trigger Raised Unhandled Exception ORA-06502

Oct 3, 2013

I have Forms 6i, installed in a system at remote location with OS Windows 7. Previously the same was installed in Windows XP it was working fine. Now in Windows 7 also its working fine for most of the things, for some data loading options its not working and showing below shown error.

FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502

View 1 Replies View Related

FRM 40735 - WHEN-BUTTON-PRESSED Trigger Raised Unhanded Exception ORA-305500?

May 8, 2007

I have a piece of code which imports data from EXCEL to ORACLE forms.But after this I am getting the exception

FRM 40735:WHEN-BUTTON-PRESSED Trigger Raised unhandled Exception ORA - 305500

My Coding is below,
PROCEDURE PROC_IMPORT_EXCEL IS
--Cursor To Get The Number Of Columns Of the table
CURSOR c_get_table_columns IS
SELECT COUNT(ATC.TBLCLMNID) FROM APPLCTN_TABLE_COLUMN ATC

[code]...

View 1 Replies View Related

Forms :: Open PDF File When Button Pressed?

Dec 6, 2009

I've a button on a form and I wrote a trigger when button pressed to open a pdf file and it worked fine this was my

declare
AppID PLS_INTEGER;
begin
AppID := DDE.App_Begin('C:Program FilesAdobeReader 8.0ReaderAcroRd32.exe Z:BUILTINS.pdf',DDE.APP_MODE_NORMAL);
end;

The thing is this form is used by multiple clients and if a user has a different version of acrobat reader rather than version 8 this will not work how to do it to be uniform?

View 5 Replies View Related

Forms :: 6i To Show Detail Block When Button Pressed?

Aug 16, 2011

Is it possible to display the detail block (different canvas) in the master block canvas, but when finished entering data into master block and a button is pressed? And i want to use some conditions in the when-button-pressed trigger. based on that it should show different canvas.

simply speaking, my aim is to use the upper part of the screen to show master block and the lower part for a detail block from the different detail blocks based on condition checked in when-button-pressed trigger.

View 6 Replies View Related

Forms :: Display Checkbox Selected Records In One Column Of Form / When Push Button Is Pressed

Jul 2, 2011

how to display check box selected records in one column of form when push button is pressed.

View 1 Replies View Related

Forms :: Trigger On Save Button

Oct 31, 2013

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

Forms :: Designing DB Application - Button Trigger?

Mar 23, 2012

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.

View 14 Replies View Related

Forms :: Enable A Button - Capture Trigger That Fires On Pressing Exit

May 23, 2011

I have a situation where one form calls another. I am opening the other form(say B) using the below code.

declare
temp_form formmodule;
begin
temp_form := FIND_FORM ('D:RSSQ2TestingpurposesMODULE3_MULTIPLE');

[code]...

On Form B there is an Exit button on click of which it closes the Form B and returns to Form A

begin
close_form('MODULE3_MULTIPLE') ;
end;

In my scenario on Exit from FORM B i need to enable a button on FORM A.I am not able to capture the trigger that fires when I Press the Exit

View 7 Replies View Related

Forms :: How To Detect When ENTER Key Pressed

Mar 5, 2010

I have 2 text fields as search criteria and a push button to search. When the user enter any on first field (or in any text field) and press ENTER key, I want to execute the search.

I tried the key-next-item trigger, but it's firing when I press TAB key.

How can I detect ENTER key?

View 8 Replies View Related

Forms :: Display A Field When Shift+f4 Is Pressed

Apr 25, 2012

i m trying to display a field when shift+f4 is pressed. but i don't know the trigger in which the code needs to be written.

View 8 Replies View Related

Forms :: Find Key Pressed And Release Action On Oracle 10g

Dec 14, 2012

we need to find the key pressed action and key release action on Oracle form 10g. On key pressed (i.e. key-up, key-down, key-page-up and key- page-down) the event will be fired and as soon as the user release the key, the event will be stop.

As current situation, we have one form which contains the database blocks. As per search condition, all the data populated in Database block, there are 1000 and more records. Now user going use any of key (i.e. key-up, key-down, key-page-up and key-page-down) as he pressed key ( say Key- down) it scrolled down but as soon as he release the key, the event is not stopped. its going on going down then stop.

Is it possible, as user release the key scrolling will stopped at same time ?

View 3 Replies View Related

Forms :: How To Clear Line Records When F11 Is Pressed In Header Block

Sep 4, 2011

I am working in form 6i, EBS 11i. I have below requirement to achieve.

I have header data block A, line control block B. My requirement is, i know that in master detail block, if i press F11 in header block, it will clear the line block, like this, in my case if i press F11 in header data block A, i want to clear the line block B. Is there any way we can achieve this.

View 3 Replies View Related

Forms :: When Pressed F-11 And Ctrl F11 Buttons Screen Doesn't Turn Blue

Oct 19, 2009

I developed custom form, everythng is working fine. but when i press F-11 & Ctrl F-11 it queries and gtes the record.

But when I press F-11 ,fields on the screen doesnt turn blue.

View 10 Replies View Related

Forms :: Call One Trigger Of Item In Trigger Of Form?

Jul 1, 2011

How can "call one trigger of item in trigger of form"

View 5 Replies View Related

Forms :: How To Add Image As A Button

May 14, 2011

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 Related

Forms :: Button On LOV - Oracle10g

May 17, 2011

I 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 Related

Forms :: Add Some Custom Image On A Button?

Dec 7, 2010

Is it possible to add some custom image on a button?

If so, How to do it?

View 8 Replies View Related

Forms :: Update Statement On Button?

Apr 16, 2010

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 Related

Forms :: Disable Save Button In 6i

Jul 22, 2011

I 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 Related

Forms :: How To Write Query For ADD Button

Jul 23, 2010

Without 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 Related

Forms :: Save Button Works Only Once?

Jun 26, 2012

declare
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?

View 5 Replies View Related

Forms :: Can't Execute Query Button

Jan 6, 2012

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 Related

Forms :: How To Hide A Button While Runtime

Mar 30, 2012

We 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?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved