Home » Developer & Programmer » Forms » Unable to save the record in the database
Unable to save the record in the database [message #459245] Fri, 04 June 2010 02:18 Go to next message
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 #459256 is a reply to message #459245] Fri, 04 June 2010 03:24 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Too few information, I'm afraid. Could you provide more details?
Re: Unable to save the record in the database [message #459299 is a reply to message #459256] Fri, 04 June 2010 05:56 Go to previous messageGo to next message
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?
Re: Unable to save the record in the database [message #459301 is a reply to message #459299] Fri, 04 June 2010 06:02 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
From memory the "Do you want to save messages" pop-up bypasses key-commit.
Put a message in key-commit to see if it's actually firing.
Re: Unable to save the record in the database [message #459368 is a reply to message #459301] Fri, 04 June 2010 09:21 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Shouldn't you, perhaps, involve ON-INSERT, ON-UPDATE and ON-DELETE Forms triggers (when dealing with a view)?
Re: Unable to save the record in the database [message #463889 is a reply to message #459368] Mon, 05 July 2010 01:56 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

David
Previous Topic: Unable to display Do you want to save the changes you have made? message
Next Topic: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle :( (merged)
Goto Forum:
  


Current Time: Fri Sep 20 08:39:59 CDT 2024