Form Problem ---You cannot update this record
Posted on 2001-06-27
Please look on my problem and let me know.
I have four blocks in the form
MAster have a Exam No. and other related fields. Question block retrieve the data from a table depending upon Exam No. Every question has multple choices Answer. Which retrived in Detail Block. In Detail block there is a field Selected. Which marks the Answer Choice.
Then there is a Block in which I want to Save Temporarily the Checked Answer, Till I issue commit.
The reason for the third block is, I issue a query for the next question depending upon the answer of the current question.
When I want to add a record in Responce_detail Block, First record can be add with out error. But after that
There is an error message "
FRM-41050: You cannot update this record. (I checked this error, it says about Block updteable property, which is Yes in My case).
But after this message Record is added in the block.
Here is the code which I use to to this job.
If :Responce_detail.AnswerID is not null then
:Responce_detail.AnswerID := :Detail.AnswerID;
:Responce_detail.QuestionID := :Question.QuestionID;
:Responce_detail.Survey_code := :Detail.survey_code;
:Responce_detail.Responce_NO := :Master.Responce_NO;
IF :Detail.Following_Question is null then
:master.Following_question := :Detail.Following_Question;
I hope all of you understand my problem.