Unable to save the record in the database [message #459245] |
Fri, 04 June 2010 02:18 |
dhanasurya
Messages: 33 Registered: May 2010
|
Member |
|
|
Hi All,
I developed one form having 3 blocks(query_find,Summary and detail).If i do some changes in the 3rd block then press F4 key
it's prompting "Do u want to save the Changes?[YES/NO/CANCEL].
If i press "YES" it displays message "1 Records applied and Saved.
But the record is not saved in the database.Why it's happening?Any reason for this?
Thanks,
|
|
|
|
Re: Unable to save the record in the database [message #459299 is a reply to message #459256] |
Fri, 04 June 2010 05:56 |
dhanasurya
Messages: 33 Registered: May 2010
|
Member |
|
|
i have 3 windows in my form.One is QUERY_FIND,Second one is SUMMARY window and the last window is DETAIL window.i created detail block based on a complex view which is placed on 3rd window.
i make that block as updatable.i am inserting the data into a custom table if i press save button.so i have written the insertion code in the KEY-COMMIT trigger at block level.if i press F4 Key it's prompting "Do u want to save the Changes?[YES/NO/CANCEL].If i press "YES" it displays message "1 Records applied and Saved.But the record is not saved in the database.
why can't save the data in the custom table?
|
|
|
|
|
|