| Commit not saving [message #298368] |
Tue, 05 February 2008 23:20  |
 |
azamkhan
Messages: 557
Registered: August 2005
|
Senior Member |
|
|
Dear Friends,
I have a Master and 3 detail blocks, e.g. Master_1, Master_Detail_2, Detail_2a & Detail_2b.
Master_1
|------- Master_Detail_2
|---------|----------|
Detail_2a Detail_2b
My forms flow is that the Master_1 block is allowed to save one record at a time, all detail blocks can save more then one record.
Now the problem is that the MASTER_DETIAL_2 block is saving only one record for Master_1. E.g.
* Suppose I have entered 1 record against Master_1 and for Master_Detial_2 it save the record no problem in that.
* When I try to enter again the 2 record in Master_Detail_2 it shows me "1 Transaction saved" without any error but when I try to see the record by execute_query on form it doesn't show me that record.
I have also checked my database table the record is not saved even there.
Could plzzzzzzzzzz any body tell me whey this is happening. Oracle says if commit is issued and the message is shown
[number] transaction is saved.
Then the record is saved but in my case it is not. And the funny part is that there is no error by Developer and not from Database.
I have tried to insert the same record into my database by sql command line and it is perfectly saving the record.
Need your help as soon as possible.
Regards,
Azam Khan
Master_1 = record 1
|------Master_Detail_2 = record 1
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
