OraFAQ Forum: Forms » No Changes to Save Error

Home » Developer & Programmer » Forms » No Changes to Save Error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

No Changes to Save Error [message #79610]

Wed, 26 June 2002 04:44

Zahid
Messages: 29
Registered: June 2002

Junior Member

Hi All,
I write the insert into....values....;Commit;statement on the button's trigger.the table has primary key too.but when i try to insert record it gave error unique constraint error.if i change the database property to NO then it show me message NO Changes to Save.
Then what is the best way to perform DML Operation on Fully constrainted Table.
Waiting for reply very badly.
LEO

Report message to a moderator

Re: No Changes to Save Error [message #79611 is a reply to message #79610]

Wed, 26 June 2002 04:49

Subhash
Messages: 105
Registered: October 2001

Senior Member

Hi,

No need to write an insert statement if it is a DB Block . Just commit;

regards

Report message to a moderator

Re: No Changes to Save Error [message #79627 is a reply to message #79610]

Fri, 28 June 2002 01:09

vasudev
Messages: 2
Registered: June 2002

Junior Member

HI,
Create an exception section & write an update stat
similar to :
UPDATE remaining col of the table/selected col WHERE
PRIMARY KEY COL = :VALUE

Report message to a moderator

Re: No Changes to Save Error [message #79668 is a reply to message #79610]

Mon, 01 July 2002 23:56

Zahid
Messages: 29
Registered: June 2002

Junior Member

Hi,
thanx for ur reply. but u did not mentions in which expection i should write this code.
Please tell me the complete instructions as the Data block's database properties are set to NO.
Waiting for your relpy very badly.
Zahid Rahim

Report message to a moderator

Previous Topic:	How to assign magic item
Next Topic:	Suppress Do you want to save changes message

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 17:55:53 CDT 2024