Forms :: Frm-40654 Record Has Been Updated By Another User

Jul 30, 2011

I 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).

View 7 Replies


ADVERTISEMENT

Forms ::create History Record For Each Record Whether Updated Or Not

Sep 13, 2011

I have a fairly standard Purchase Order form which contains pre-loaded data (been uploaded from an XML file).When the Purchase Order is processed, the form updates a Price History table only if the Price on the PO_Details changes.The code for updating the price history table is contained in a PRE_UPDATE trigger on the PO_Details Data Block.

No other data changes on the PO_Details table.I now want to change this so that the Price History table is updated even if the price does not change i.e I want to create a history record for each record on the PO_Details irrespective of whether it was updated or not.

Is there an alternative trigger that I can move my code to (ie move it from PRE_UPDATE) to some other trigger that is fired for each PO_Details record even if there is no change.

View 4 Replies View Related

Forms :: Save Record In Table Before Saving Updated Version?

Apr 6, 2013

I have a multi record block . I need to implement a functionality where the user updates a field in the record but the form saves the previous version of the record in another table ..

View 3 Replies View Related

Forms :: FRM-40654 On Some Rows Only?

Jun 27, 2013

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

View 2 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

PL/SQL :: How To Get The Record Before Updated

Sep 3, 2012

I have a problem where my record is updated yesterday. How to get the record before updated?

View 4 Replies View Related

Forms :: When User Change / Delete Any Record / Row In Forms Data Automatically Move To Other Table

Dec 25, 2011

when a user change or delete any record or row in forms data automatically move to other table because i want to compare old and new record.

View 8 Replies View Related

SQL & PL/SQL :: How To Select Latest Updated Record From Table

Sep 21, 2011

I want to know like How we can select the latest updated record from xyz table. that record has STATUS column. I also want to check if the status is RED or GREEN query should return if the status is red then 1 and if the status is GREEN then it should return 0

View 8 Replies View Related

SQL & PL/SQL :: Every Record In Temp Table Getting Updated With LAST In Datafile?

Nov 24, 2010

is that my looping script updates EVERY record with the LAST record of the datafile. where it's doing this..

DECLARE....
CURSORS...
-- *****************************************************
-- C 1
-- *****************************************************
CURSOR C1

[code]...

View 19 Replies View Related

Forms :: Display All Records One By One As User Click On Next Record Button

Jul 13, 2010

I have created one tab canvased form

On first tab I am taking input (search criteria)
on that input i am trying to display all records one by one as user click on next record button....

for that i used when-tab-page-change trigger for first record display and it display correctly.but for further record what should i need to write on next_record command button so all record i can see one by one.

View 1 Replies View Related

Forms :: Force User To Save Or Discard Record Before Child Window?

Aug 10, 2012

I have created a form where the main canvas has number of buttons. When I click each button it will open a new canvas in a new window. User will enter some details there. now I want to force the user to save or discard the record before they leave that child window. The code I have written is

DECLARE
n_button_selection INTEGER;
BEGIN
IF :SYSTEM.BLOCK_STATUS = 'CHANGED' then

[code]...

But I am not sure in which trigger I need to write the code. When I am writting in post block it is behavior is becoming unpredictable and also APP_STANDARD.EVENT('KEY-COMMIT') does not work in post_block trigger. When I am writting this in ON close trigger then also it is not firing as expected.

View 1 Replies View Related

Application Express :: Tabular Form - When Row Updated / Add User ID And Timestamp To Row

Apr 30, 2013

I have a simple tabular form based on a four element table: the primary key (seq #), title, Updated_by, Updated_timestamp.I would like to populate the updated_by and Updated_timestamp fields when a user either updates or adds to the table.On other forms, I use a calculation to update the page_ item in the page_processing section of APEX. However, in the tabular form, I am not sure where I might update these two fields.

View 2 Replies View Related

Forms :: Details Should Be Updated From One To Other Table

Mar 19, 2011

when the tables are updated, the following detals must be correct to ensure that the links in the affected tables are in place.

PLUPDATE_NEW(PLUP_SAVE_SEQ field value) must be the same with PLUPDATE_BENEF_NEW (PLUP_NEW_BENEF_SAVE_SEQ field value)
PLUPDATE_OLD(PLUP_SAVE_SEQ field value) must be the same with PLUPDATE_BENEF_OLD (PLUP_OLD_BENEF_SAVE_SEQ field value)?

[Code]....

i tried this code, what should i do in the link for this tables?

View 5 Replies View Related

Forms :: Auto Refresh When Data Updated

Apr 19, 2010

i need a code to auto refresh or after 1 minute in form & report when the data is updated. basically i am deploying the plasma tv in hall so executive can see the status report where they need its going to be like a stock system multiple forms or reports sticky dynamically change .

View 2 Replies View Related

Forms :: How To Check Particular Item Updated In A Block

Mar 1, 2010

I have a form in which i had 6 items in a block,like sno,task,responsible,totaldays,date,status .Except 'totaldays' item all items will be updated when i press button called 'Update'.am doing this in on - update by using if(:system.block_status='changed').

Now i want only if a specific item 'totaldays' is changed , the on-update should happen.

i have 6 items in a block
sno
task
responsible,
totaldays
date,
status

only if i change totaldays item the on - update should happen

how to do this?

View 3 Replies View Related

Forms :: How To Use Updated Temptable Data In Report

Apr 26, 2010

I have the manipulated data on temporary table name "tempdata" and i want to display it in to my report, I am using the temporary table, and also call report from the same session on which data is updated on temporary table. but its still not showing data on the report, I think this is the session problem of the form but i also call report from the same form , so the session should b same for both the report as well as for the form, so y don't the report show the temporary table data.

View 39 Replies View Related

Forms :: Report Through Form - Updated File Not Executed

Apr 7, 2011

I am using Forms / Reports Developer Version 6. When I run the report through form the Report runs but updated file was not executed. The path from which I run report through form contains updated report name. When I run report by using Report runtime shortcut then updated report will run. The report path mention in form using run_product also contains the updated file but didn't execute the updated file.

View 1 Replies View Related

How To Not Let User With DBA Role To Delete Record From Sys.aud$

Sep 20, 2012

we have certain users have DBA role assigned. of course they can delete records from sys.aud$.

we are trying to make this go away. we found that in DBA role, there is a role called DELETE_CATALOG_ROLE controls this. if we revoke this role from DBA role, user no longer able to delete records from sys.aud$ but the problem is as a powerful user who has DBA role, they can always grant this back to DBA role, or grant delete from sys.aud$ table directly to themself.

can we create a second role which just like DBA role, but with less privileges?

View 7 Replies View Related

Forms :: Populating Values To Record Group From Multi Record Datablock

Jul 26, 2012

My procedure proc_ex is in when_validate_item trigger

I have one Multi Record data block in my form with values in its items

I need to Populate multi record block values to one Record Group using

add_group_row,
add_group_column,
set_group_char_cell to populate values to record group

Let us suppose my multi record data block looks like

item1 item2 item3 item4
10 20 50 70
25 15 30 45
45 90 47 38
75 25 85 90
30 56 78 80

how to populate these multi record datablock values to Record Group ???..Eagerly waiting for your Replies

View 3 Replies View Related

Forms :: Only New Record Have Saved Last Record No Longer Exist

Jun 29, 2013

I create a data block on a table when I am inserting new record only one record have been saved. Last record no longer exist.

View 4 Replies View Related

Server Administration :: Record Audit Info About Sql Statement Run By User

Jul 19, 2012

I am trying to record audit info about sql statement run by user (only one audit entry per specific type of operation such as create table, or insert table). Such as if a user create three tables, but database record only one entry of create table type per session.

I am giving you all the statement I issued...

SQL> create user saimon identified by abc1;

User created.

SQL> grant connect, resource to saimon;

Grant succeeded.

SQL> audit table, insert table by saimon by session;

Audit succeeded.

SQL> show parameter audit

NAME TYPE VALUE
-------------------- ----------- -------------
audit_file_dest string /u01/app/oracle/admin/orcl/adum
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DBSQL>

[oracle@DBTEST ~]$ sqlplus saimon/abc1

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jul 19 21:45:09 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

SQL> create table TB1 (id number, name varchar2(20));

Table created.

SQL> create table TB3 (id number, name varchar2(20));

Table created.

SQL> select USERNAME, TERMINAL, OS_USERNAME, USERHOST, ACTION, action_name, OBJ_NAMe
2 from user_audit_trail;

USERNAME TERMINAL OS_USERNAM USERHOST ACTION ACTION_NAME OBJ_NAME
---------- ---------- ---------- ----------------- ----------------------- ----------
SAIMON pts/4 oracle DBTEST 1 CREATE TABLE TB3
SAIMON pts/4 oracle DBTEST 1 CREATE TABLE TB1
conn / as sysdba

Now my question is I have enabled statement auditing for session not by access. So only one audit entry should have been recorded for two table creation. Why database is recording every create statement?

SQL> show user
USER is "SYS"

SQL> SELECT audit_option, failure, success, user_name
2 FROM dba_stmt_audit_opts;

AUDIT_OPTION FAILURE SUCCESS USER_NAME
----------------------------------- ---------- ---------- ------------------------------
TABLE BY SESSION BY SESSION SAIMON
INSERT TABLE BY SESSION BY SESSION SAIMON

View 2 Replies View Related

Application Express :: Updating Record As Apex_public_user instead Of Login User?

Sep 9, 2013

I have created an application as database authentication.In the application, I  have developed a screen based on a tabular form,when I try to update a  record ,the record is updated with apex_public_user insted of the database login. 

View 3 Replies View Related

Forms :: On-Update Trigger To Replace Default Form Builder Processing For Updated Records

Mar 8, 2007

I'm using an 'On-Update trigger' to replace the default Form Builder processing for updated records. When I try to change a column in the form I get: ORA- 01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.

The on-update doesn't fire. How do I get around this. The block is based on a view.

View 9 Replies View Related

Forms :: Choose Lov In First Record That Won't Be Display In Second Record Lov

Sep 10, 2012

I have one multi record block in that i have one LOV..If i choose lov in first record that won't be display in second record lov...

View 4 Replies View Related

Forms :: User Privileges - Assign Permissions To One User To Add / Delete / Edit Data?

May 28, 2011

how can i assign permissions to one user to add,delete,edit data and other user should be able to perform all functions or selected functions

View 12 Replies View Related

Oracle 11g - Record Query And Time To Fetch Results For A Specific User ID

Jul 22, 2013

I have an application connected to Oracle 11g that sends its own querys to the db based on what the user is clickng on. The applicaiton is connected via one user id and I was wondering, is there a way that I can capture the tiem each query starts, the sql itself, and the amount of time it took to fetch the data?

View 7 Replies View Related

Forms :: Login User From One CANVAS And Access Second As Per-user Rights?

Oct 20, 2012

- we have user id parameter.can we update the parameter(:parameter.p_userid) before firing "WHEN NEW FORM INSTANCE TRIGGER"(when new form instance trigger contain code for tree node), for login another canvas as per user rights?

- i have created a login form in one canvas.

- also tree node Hierarchy form created on another canvas. now we want to login through login screen, after login only those forms should show in tree Hierarchy which users have rights. for this purpose we want to pass the parameter of userid before connecting to tree node form through the following query

SELECT COUNT (*)
INTO v_count
FROM usersinfo
WHERE usersname = :USERBLOCK.usernames AND passwords = :USERBLOCK.passwords ;

[code]...

Every thing is working but when we click on button in login form at that time parameter.p_userid will return null. because above code is define on button click in login screen, i cannot understand where i need to define the above code .

View 1 Replies View Related

Forms :: Insert Record Into Lov Through Oracle Custom Forms?

Oct 8, 2013

I have a LOV in a custom oracle forms.this lov is linked to a record group.

Presently the column on which lov is created does not contain any value.

I want to insert value into the lov through the forms.

I am not able to insert data into it through forms

View 12 Replies View Related

Forms :: Update Database Item When Non-database Item Is Manually Updated?

Mar 10, 2011

I am having trouble changing a non-displayed field when a displayed field is changed.

When a user wants to un-assign a territory they want to just null the ID field (non-database item). I then need to null the PIDM field(not visible, database item) for that one record.

I tried this, but I end up putting null on all the records instead of just the one record, which ends up un-assigning all the territories not just the one.

Is there a way to assign the null to the PIDM field associated to the ID field of that particular record.

View 6 Replies View Related

Forms :: Do You Want To Save Record

Aug 22, 2005

I have created a form which as two block as master and detail.I am facing two problem in my detail block.

First: When I populate records in detail block, it prompt a message 'Do you want to save record ?'.
Second : When I alter any value in detail block and move to next record, it prompt a message 'Do you want to save record ?'

Is there any way where, system don't prompt me a message for saving record and user can continue with changes and save the records when he desire.

View 16 Replies View Related







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