The KC Ballet has a custom tab holding student information. One of the fields is a drop down with 4 possible choices.
If you pick one of the "Former" options, everyting saves correctly. If you pick one of the first two choices, the value reverts to one of the "Former" options.
I ran a trace and all I see is the update statement (with the correct choice) followed by a call to ap_set_context. I don't think that the ap_set_context call is the issue but I am a little stumped on where to look next.
Has anyone seen something similar in the past? It seems like there is a trigger or another SP call that I'm not seeing in the trace that's causing it. But I can't locate it.
Levi,
good day.
What did the update script said in SQl profiler?
A,
If the update statement is wrong, then you need to check the reference of the dropdown list.
try to find out how they link together. What is value field, and what is the display field?
B,
If the update script is right, then you need to check why script cannot update the table.
Is there a trigger? Updated a record with wrong id_key? or check the wrong table? or wrong database?
You can right click the table name, select 'View Dependencies' to check out.
I think ap_set_context has nothing to do with the updating.
have fun.
Ben