Forms :: Form Generate Message Frm-40654
Sep 1, 2011what 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
ADVERTISEMENT
Forms :: Show The Message In Form Personalization
Aug 9, 2010I 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 RelatedForms :: Oracle Form Login - No Warning Message After 5 Minutes
Nov 11, 2009Is 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.
Forms :: How To Generate PDF Report From Form Developer 6i
Sep 21, 2010I want to generate a PDF report from Form Developer 6i.
View 5 Replies View RelatedForms :: Data Entering Form Not Showing Any ERROR Messages / SAVE RECORD Message
Jan 15, 2013I 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.
Forms :: FRM-40654 On Some Rows Only?
Jun 27, 2013I developed a small app using forms, which queries a table in our DB and allows the user to edit some of the values in a grid-like format. Sometimes I get this FRM-40654 error when trying to key in a value in a column. Sometimes means that it may happen or not happen at all, but also that it happens on some of the queries rows and not on others. IN one case I have 4 rows and it happens on all but the 2nd The table has a small trigger on it:
CREATE OR REPLACE TRIGGER MFI_CT_T_TRG1
before UPDATE ON MFI_CITY_TAX_T
REFERENCING OLD AS old NEW AS new
FOR EACH ROW
BEGIN
:new.modified_on := sysdate;
:new.modified_by := pms_p.logged_uid;
END;
/
But I tried already to remove it and it didn't work.I set the DML Returning Values of the block to Y, still the same.
Forms :: Frm-40654 Record Has Been Updated By Another User
Jul 30, 2011I am working on form 6i, database 9i.
I have a table(emp): empno, ename, job, created by, creation_date
My form :
windows: 1. main window 2. find window
Main Window: It contains data block(emp block) on table emp. Shows 'empno', 'ename', 'job', 'INSERT' button,and 'UPDATE' button.
Find Window: It contains 'empno', 'ename', 'job','created_by','creation_date', and 'FIND' button.
If i search through FIND window, it will fetch the data from 'EMP' table and shows in MAIN window, emp block.
FIND BUTTON: SELECT empno, ename, job
FROM emp
WHERE empno=:blockemp.empno
AND ename=:blockemp.ename
AND job=:blockemp.job
AND created_by=:blockemp.created_by
AND creation_date=:blockemp.creation_date
[code]....
If i query data(F11) on block emp, i can update data any number of times, it's working fine.But if i search through the FIND window, if i udpate a record, first time, it's updating; but second time if i try update the record,it's giving below error.
ERROR:frm-40654 Record has been updated by another user.Re Query to see change
I understand that it's locking the table if manually update it(when i search data through FIND window).
Forms :: Generate Unique Document Numbers When More Than One User Inserting In Form At One Time
Dec 5, 2011I have made one application form where users need to enter some data. This data is getting inserted in four tables. As in for now the data is properly getting saved and retrieved only for one user at a time. But problem arrives when more than one users are simultaneously making an entry and saving the data at one time.Same number is getting generated for the users who are saving the data at one time which should not happen.
View 4 Replies View RelatedApplication Express :: 4.1.1 - Tabular Form Updated Row Message
Oct 31, 2012In my Application I have a tabular form and they other I edited 1 row & 1 entry and clicked on the update button. The message on the top says:
16 rows updated, 0 rows inserted (the standard message).
I do not have any page processes before or after applyMRU and its one of those freaky one-off issue that I can't reproduce again. Update 1 row and shows 15 updates.
Here are some info regarding my tabular form:
8 columns, pagination enabled for 20+ rows, no insert or delete functionailty, just updates.
Forms :: Cannot Commit Form When New Instance Form With Form Status Is NEW
Apr 17, 2012I cann't commit form when new instance form with form status is "NEW".
And then i call:
Text_Item := WebUtil_File.File_Selection_Dialog('', '', 'Excel 2003|*.xls|Excel 2010|*.xlsx|All File|*.*', 'Select a file to Import', Open_File, True);
Form status change to "QUERY"
And then i click button "Import Data" from excel file to Data Block. Now form status change to "CHANGED". But i cannot call "Commit_Form" built-in to insert data to database oracle 10g.
Forms :: Clear Block Message In Oracle Forms?
Nov 30, 2012I 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.
Forms :: Opening Form Has Attached Libraries Caused Form Close
Jul 19, 2010If I open a form has attached libraries in form builder on windows7 it closed and give this message :
Problem signature:
Problem Event Name:APPCRASH
Application Name:frmbld.exe
Application Version:10.1.2.0
Application Timestamp:42d63632
Fault Module Name:KERNELBASE.dll
[code]......
Forms :: Want To Call Web Form For Uploading Image From Custom Form
Apr 16, 2013I want to call a Web form which should upload the image from my local machine.For that I have created a form which will take necessary data about employee now I want to Insert Image for that employee into table as I am new I struct on the Image uploading form. Latter I have seen the Enter & Maintain form which have Picture button.Pressing this button we get one new web form open & we can upload our image from there.
View 1 Replies View RelatedForms :: How To Reload Calling Form After Closing Called Form
Jul 15, 2007I have FORM_A calling FORM_B: Call_form('FORM_B',...). On form_B I am updating a Record and when I close Form_B and the focus goes back to Form_A, I need to Automatically Reload Form_A to reflect the changes that were made on Form_B.
How can I reload the Calling Form (FORM_A) when I closed the called form (FORM_B)?
Forms :: Message Is Not Displaying?
Feb 14, 2012i 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 RelatedForms :: Message From Webutil?
Apr 3, 2012I'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 RelatedForms :: Changing Message Type
Nov 14, 2011Some time we use message function in oracle forms.
message('...');
can we change the type of this message? Icon should be caution instead of Stop.
Forms :: How To Avoid FRM-40401 Message
Oct 16, 2008While 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 View RelatedForms :: How To Stop System Message
Nov 3, 2010I 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 RelatedForms :: How To Remove Message That Come Automatically
Mar 2, 2010How can I remove (record asved) message that come automatically after commit??
View 5 Replies View RelatedForms :: How To Hide Pause Message
Jul 20, 2010I need to hid the PAUSE Message "Please acknowledge". when I use PAUSE key word and replace it with another message
View 1 Replies View RelatedForms :: 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
Forms :: Change Background To Logo Message
Jun 30, 2010I 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 RelatedForms :: Error Message - Could Not Reserve Record (2 Tries) Keep Trying
Apr 21, 2011when 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 RelatedForms :: 2 Different Form To Pass Values From One Form To Another
Mar 11, 2010is there any type of veriable used in declate statement whith could be used in 2 different form to pass values from one form to another.
View 1 Replies View RelatedForms :: Displaying A Warning Message If No Detail Saved
Jul 25, 2011I 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 RelatedForms :: Send Message To Lantronix Network Device?
Sep 15, 2011how 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 RelatedForms :: 10g - Send Text Message To GSM Mobile Device?
Aug 28, 2010through oracle forms 10g how can i send a text message to a GSM mobile device...
View 2 Replies View RelatedForms :: Declare Message For @ Is Not Type In Email Address
Oct 24, 2011i 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;
Forms :: Customize Position Of ALERT Message On Screen As Per Requirement
Mar 19, 2010I 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