| DISABLE COMMIT ON database BLOCK [message #339743] |
Fri, 08 August 2008 05:57  |
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  |
 |
Littlefoot
Messages: 21823
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?
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
