Forms :: How To Avoid FRM-40401 Message

Oct 16, 2008

While I am inserting and updating the values in the oracle database its showing a message 'FRM-40401 - No changes to save.' I don't want this message to be shown. How can I do that?

View 5 Replies


ADVERTISEMENT

Forms :: FRM-40401 No Save To Change?

Jun 17, 2011

I have updated a table from the form and written a update statement ON block level trigger ON-UPDATE

"UPDATE_RECORD;
update employees set hiredate=to_date(:EMP.TXT_DATE,'dd-MON-yyyy')
where employees.empno=:emp.empno;
COMMIT_FORM;"

Here employees is my table and emp is my block

View 6 Replies View Related

Forms :: Avoid Duplication In Three Tables

Jan 31, 2013

I'm creating oracle form to allow the user to register a new record in a table, I want to check the duplication in Four tables! which means, the user is able to save the record if it's NOT already registered in the other four tables.By checking P_ID (user parameter). this is my

Declare
v_count number;
begin
select count(*) into v_count ---Checking the 1st table
from 1_table
where p1_id=:p_id;
if (v_count>0) then
message ('Duplicate');
[code]....

View 4 Replies View Related

Forms :: Avoid The User To Select Twice The Same Value From LOV?

Aug 21, 2010

i have created form. one field is there "Payment_terms" at line level. for that i created LOV containing 3 fixed Payment terms. my requirement is that Avoid the user to select twice the same value from LOV.

View 8 Replies View Related

Forms :: Avoid Duplicate At Entry Level

May 17, 2011

How can i avoid duplicate entry at entry level in form rather than when i pressed save button

View 2 Replies View Related

Forms :: Clear Block Message In Oracle Forms?

Nov 30, 2012

I am creating a form with 3 blocks.

Control block,
Header Block,
Detail Block.

First i have entered a record in the control block.

Then i navigate to header block,entered the first record for Header Block.

Then i navigate to Detail block,entered the first record for detail Block.

then i again navigate to Header Block..

Now the Problem comes....As i am Trying to enter second record for header block,the pop up comes as "Do you want to save the changes".

Condition 1:i dont want that message to appear for every header record i enter.

Condition 2:For every header record i enter,Corresponding detail record would have been entered.i want that detail records to be retained if i am clicking that header record as i have already created relationship for both header block and detail block.

View 1 Replies View Related

Forms :: Message Is Not Displaying?

Feb 14, 2012

i got an error running my form. And when i re-run it again, the message at the bottom was nowhere to be found. How can i bring it back?

View 3 Replies View Related

Forms :: Message From Webutil?

Apr 3, 2012

I'm migrating some forms from 6i to 9i and one of them has to use the webutil library, but when I execute the form in the IE, a message appear and I don't know from where because I haven't made it. The message say: "Confirme el mensaje" This is a print of the message,

View 3 Replies View Related

Forms :: Changing Message Type

Nov 14, 2011

Some time we use message function in oracle forms.

message('...');

can we change the type of this message? Icon should be caution instead of Stop.

View 1 Replies View Related

Forms :: How To Stop System Message

Nov 3, 2010

I have a form with multiple data block. When i want to query and go to next record then this displayed a message "Do you want save changes". But i would like to stop this message(i.e would not see the message) is it possible.

View 3 Replies View Related

Forms :: How To Remove Message That Come Automatically

Mar 2, 2010

How can I remove (record asved) message that come automatically after commit??

View 5 Replies View Related

Forms :: How To Hide Pause Message

Jul 20, 2010

I need to hid the PAUSE Message "Please acknowledge". when I use PAUSE key word and replace it with another message

View 1 Replies View Related

Forms :: Showing Message When Canvas Changing?

Jan 6, 2012

I am facing one confusion with canvas changing and message displaying issue i have one login page. in that there are three fields username,password and department in the department i having 5 departments including salesandmarketing

the requirement once i entered every credentials correctly and i am logging in as salesandmarketing. When the salesandmarketing canvas opens a message should display saying "you are successfully entered into sales and marketing".

i have my home page as content canvas and sales and marketing as tab canvasi need to do the same message when i am entering into 5 departments with corresponding department name in the message end instead of salesandmarketing
is it possible to do with when_new_canvas

View 1 Replies View Related

Forms :: Change Background To Logo Message

Jun 30, 2010

I want to change the Background "Oracle Forms AS services" to one of our logo. I searched in formsweb.cfg and tried many parameters. I got succeeded in changing Title, forms background but not able to change the oracle logo message in the white background of html web page.

View 2 Replies View Related

Forms :: Show The Message In Form Personalization

Aug 9, 2010

I call the one procedure in post_insert which submit the concurrent request and send the email to specific email address. Now i want to show the message, when email is send that "Your msg is send to ....."

View 5 Replies View Related

Forms :: Error Message - Could Not Reserve Record (2 Tries) Keep Trying

Apr 21, 2011

when i running my form i m receiving this error message Error Message is "Could not reserve record (2 tries) keep trying ? " This is due to multi user Login, How can i avoid from this error message.

View 26 Replies View Related

Forms :: Form Generate Message Frm-40654

Sep 1, 2011

what is this error.it will come on after save record on table through form.

FRM-40654:Record has been updated by another user.Re-query to see change

View 2 Replies View Related

Forms :: Displaying A Warning Message If No Detail Saved

Jul 25, 2011

I have 2 blocks, block 1 which is the master and block 2 which is the detail. Both block 1 and block 2 are multi record blocks. For my form I want to display a warning message to the user if they create a master block without also creating a detail.

View 2 Replies View Related

Forms :: Send Message To Lantronix Network Device?

Sep 15, 2011

how I can send a message from Oracle Forms 10g to a Lantronix terminal server? It is a TCP/IP front end to a serial port controlling a warehouse carousel. We want to send a command string to a ip_address:port_number in raw mode. We have tested it using a telnet session. I develop in PL/SQL, just never used forms.

View 2 Replies View Related

Forms :: 10g - Send Text Message To GSM Mobile Device?

Aug 28, 2010

through oracle forms 10g how can i send a text message to a GSM mobile device...

View 2 Replies View Related

Forms :: Declare Message For @ Is Not Type In Email Address

Oct 24, 2011

i want if user is not type the @ in email text box than from show the message "check your email address" but i cant do that

declare
ok_flag number :=0;
begin
ok_flag :=instr('emailaddress','@');
if
ok_flag < 1 then
message('invalid email');
else
message('thanks');
end if;
end;

View 8 Replies View Related

Forms :: Customize Position Of ALERT Message On Screen As Per Requirement

Mar 19, 2010

I am using Oracle developer Suite 10g, and i want to customize the position of ALERT message on the screen as per requirement.

View 4 Replies View Related

Forms :: Oracle Form Login - No Warning Message After 5 Minutes

Nov 11, 2009

Is there any way to make a form timeout.

After login into form if there is no transaction/event happens I want it to throw one warning message after say 5 minutes.

View 9 Replies View Related

Forms :: Unable To Display A Message When Record Status Is Changed?

Jun 2, 2010

I have one requirement.i.e I want to display 'Do you want to save the changes you have made?[YES/NO]' message when record status is changed.In my form if i enter some value to the actual qty(db item) and press 'x' button it does't prompting 'Do you want to save the changes you have made?' message.

For displaying this message i have written following code in the APP_CUSTOM body:

IF (wnd = 'XXMZ_MRS_DET')
THEN
lv_wnd_stat := get_window_property('XXMZ_SUMMARY',VISIBLE);
if lv_wnd_stat = 'TRUE' THEN
IF :SYSTEM.form_status = 'CHANGED' THEN
CLEAR_BLOCK(ASK_COMMIT);
ELSE

[code]....

if i write above code in the app_custom body it's prompting the above message.But if i click 'YES' it does't save the records?

How can i save the records when i click 'yes'?

View 3 Replies View Related

Forms :: How To Hide Oracle In-built Message Which Appears At Bottom Of Window

Mar 18, 2011

How to hide oracle in-built message which appears at the bottom of the window(just above the task-bar) to the left side.

View 2 Replies View Related

Forms :: How To Avoid (no List Elements Defined For List Item) Error

Sep 27, 2011

I am creating the Dynamic list but when i am compiling the form it gives the compilation error "No list elements defined for the list item".

I can eliminate it by entering the dummy list element but this dummy value will be displayed at form run time.

View 1 Replies View Related

Forms :: Data Entering Form Not Showing Any ERROR Messages / SAVE RECORD Message

Jan 15, 2013

I developed a form in forms9i, at the time of data entering form is not showing any ERROR messages or SAVE RECORD message and when I press exit button it is asking "DO YOU WANT TO SAVE THE CHANGES YOU HAVE MADE".

I have checked my PRIMARY KEY field and there is no mistake and value is populating at PRE INSERT.

View 2 Replies View Related

How To Avoid Ora-03134

Apr 19, 2011

We have Oracle 8i, 9i, 10g and 11g. I installed oracle client 11gR2 and when I tried connecting to the database, its erroring out saying "ORA-03134 connections to this server version are no longer supported". What client version should I install in order to avoid this error?

View 2 Replies View Related

SQL & PL/SQL :: How To Avoid Max Function

Feb 22, 2010

I have two tables where I have to find the record for Max value of the column sap_pkid for every sap_id as in given table create script. This script is giving correct value but looking for a better way so that when data increses it doesn't hit the performance.

way where max can be avoided or a more tuned query .

create table tab1 (sapid number,
denid number);
create table tab2 (sap_pkid number ,sapid number,
denid number,

[code]...

View 2 Replies View Related

SQL & PL/SQL :: Avoid Divisions By Zero?

Feb 25, 2013

I have a query that performs the sum of a field and divides by the number of occurrences, got me a problem because if there are no occurrences would cause a divide by zero error in Query.

The solution I found might not have been the best, but at the time was possible.

I put a Case, when the sum of the number of occurrence is zero then return zero, otherwise performs the division of the sum of the values by the number of occurrences.

SELECT CLIENT_ID,
TO_NUMBER(TO_CHAR(DTPROC, ''YYYYMM'')),
DTPROC, EXCHANG_VAL,

[Code]....

Now this query is very slow, because have CASE,SUM and GROUP BY, so I need to optimize it.

do this validation (if the divisor is zero) more performance?

View 5 Replies View Related







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