Home » Developer & Programmer » Forms » DISABLE COMMIT ON database BLOCK
DISABLE COMMIT ON database BLOCK [message #339743] Fri, 08 August 2008 05:57 Go to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
hi ppl
i have two database blocks , there is no relation between them.
i make changes in data of both blocks.
when i execute
Commit ;
both the block save as both are database .
I WANT ONE OF THEM TO SAVE CHANGES INTO TABLE AND OTHER BLOCK NOT TO SAVE THE CHANGES.


REGARDS
IMTIAZ
Re: DISABLE COMMIT ON database BLOCK [message #339749 is a reply to message #339743] Fri, 08 August 2008 06:30 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Not possible, as far as I can tell. Commit all or nothing.

It is the same as if there were these SQL statements:
INSERT INTO employees (id, name) VALUES (1, 'Littlefoot');

INSERT INTO departments (id, name) VALUES (10, 'Mining');

COMMIT only_insert_into_employees;

Obviously, can't be done. COMMIT will save changes into both tables, not only one of them.

By the way, why do you make changes if you don't want to save them?
Re: DISABLE COMMIT ON database BLOCK [message #339754 is a reply to message #339749] Fri, 08 August 2008 06:35 Go to previous messageGo to next message
sispk6
Messages: 164
Registered: November 2006
Location: pakistan
Senior Member
I WANT TO LET MY USER PLAY WITH VALUES FOR A BIT , BUT DONT LET HIM SAVE THOSE CHANGES ,
LIKE TEST VALUE
Re: DISABLE COMMIT ON database BLOCK [message #339757 is a reply to message #339754] Fri, 08 August 2008 06:43 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How will you decide when this "playing a little bit" period expires in order to let him/her commit changes?

In my opinion, testing and education should not be done in production. Create (or ask your DBA to do it for you) environment which will be used for such purposes.
Re: DISABLE COMMIT ON database BLOCK [message #339843 is a reply to message #339754] Fri, 08 August 2008 19:52 Go to previous message
sachinjainonweb
Messages: 24
Registered: October 2005
Junior Member
Write NULL; in ON-INSERT,ON-UPDATE and ON-DELETE triggers to do something like BLOCK level commit

Luck Always
Previous Topic: Problem setting Mater Detail relation
Next Topic: Query Problem
Goto Forum:
  


Current Time: Mon Dec 05 18:49:33 CST 2016

Total time taken to generate the page: 0.15153 seconds