I have a question event that is set to "
Set question default / return SQL response based on another questions response"
It is supposed to set the value of a textbox using whatever returns from a stored procedure.
The stored procedure looks like this:
EXEC MyStoredProcedure $(SourceUserID), $(TargetUserID)
This question event is not working when the stored procedure call looks like what I have above, with the references to the two other shortFieldNames, but it does work when I type the stored procedure with real values like this:
EXEC MyStoredProcedure 1187, 344
So I think I have most of this right except the question event is not substituting the actual values of the two other shoretfieldnames at the time it is called. So I think the question is, Why is it not using the values of the other two fields?
The other two fields are both combo boxes with default values and choices made by the user before calling the question event.