I have seen this happen many times before. You are willing to bet your life that a condition is true, in this case b_sched.pref_lvl11 = 3. I am betting that this condition is not true. Maybe a simple spelling error? Try to type it again, and see what happens.

>This is exactly my point - I am trying to trace in the Debugger. As soon as I hit this line
>

>case b_sched.pref_lvl11 = 3  && true
>	   =MESSAGEBOX(b_sched.base_id)
>	   =MESSAGEBOX( seek(b_sched.base_id, 'csrTemp1', 'base_id'))
>	    
>	    if not seek(b_sched.base_id, 'csrTemp1', 'base_id')
>			lcReqOK = 'Booking requiring specific instructor base would be violated'
>        endif
>

>the cursor immediately goes to the endcase line. Why it doesn't even attempt to get me my messageboxes I added out of the desperation?
>
>I don't think the coverage will provide any more insights here. I even started to wonder if I understand how case works in VFP. I have a condition which is true. Why no code inside the case statement is executed?
>
>>>Hi everybody,
>>>
>>>I have a form with an ActiveX control. The form's base class has an Error method defined and I've seen it firing.
>>>
>>>One of the ActiveX control event is calling several form's methods (one method is calling another method).
>>>
>>>One method is called CheckInstructorPreferences and it starts with the following code
>>>
>>>

>>>text TO lcSQL TEXTMERGE noshow
>>>       DECLARE @Instr_ID CHAR(12);
>>>       SET @Instr_ID = <<VFP2SQL(m.tcInstructor)>>;
>>>       
>>>        SELECT instr_id, sex, tch_level, snb_level, tele_level, misc_level,
>>>          criteria_2, criteria_3, criteria_4, criteria_5, on_job, experience,
>>>          pop_up1_1, pop_up1_2, pop_up1_3, pop_up1_4, pop_up1_5, pop_up1_6,
>>>          pop_up1_7, pop_up1_8, pop_up1_9, pop_up1_10, pop_up2_1, pop_up2_2,
>>>          pop_up2_3, pop_up2_4, pop_up2_5, pop_up2_6, pop_up2_7, pop_up2_8,
>>>          pop_up2_9, pop_up2_10, pop_up2_11, pop_up2_12, pop_up2_13, pop_up2_14,
>>>          pop_up2_15, pop_up3_1, pop_up3_2,
>>>          pop_up3_3, pop_up3_4, pop_up3_5, pop_up3_6, pop_up3_7, pop_up3_8,
>>>          pop_up3_9, pop_up3_10, pop_up3_11, pop_up3_12, pop_up3_13, pop_up3_14,
>>>          pop_up3_15
>>>     FROM dbo.b_instr
>>>     WHERE instr_id= @Instr_ID <<m.lcSupervisorFilter>>;
>>>     
>>>     SELECT * from dbo.b_in_bs WHERE instr_id=@Instr_ID;
>>>
>>>ENDTEXT
>>>
>>>mysqlexec(m.lcSQL, 'csrTemp', program())
>>>
>>>select csrTemp1
>>>index on base_id tag base_id
>>>select csrTemp
>>>&&STEP 1 - would this new booking conflict with guest requirements?
>>>if alltrim(csrTemp.instr_id)==m.tcInstructor      &&found instructor?
>>>	do case
>>>	case b_sched.pref_lvl2=3 and not csrTemp.sex=b_sched.sex
>>>		lcReqOK = 'Booking requiring a specific gender would be violated'
>>>	case b_sched.pref_lvl4=3
>>>		if !empty(b_sched.whichlevel)
>>>			lcWhichLevel = lower(alltrim(b_sched.whichlevel))
>>>			do case
>>>			case m.lcWhichLevel = 'tch_level' and not csrTemp.tch_level>=b_sched.tch_level
>>>				lcReqOK = 'Booking requiring a minimum alpine level would be violated'
>>>			case m.lcWhichLevel = 'snb_level' and not csrTemp.snb_level>=b_sched.snb_level
>>>				lcReqOK = 'Booking requiring a minimum snowboard level would be violated'
>>>			case m.lcWhichLevel = 'tele_level' and not csrTemp.tele_level>=b_sched.tele_level
>>>				lcReqOK = 'Booking requiring a minimum telemark level would be violated'
>>>			case m.lcWhichLevel = 'misc_level' and not csrTemp.misc_level>=b_sched.misc_level
>>>				lcReqOK = 'Booking requiring a minimum other level would be violated'
>>>			endcase
>>>		endif
>>>	case b_sched.pref_lvl11 = 3 
>>>	    if not seek(b_sched.base_id, 'csrTemp1', 'base_id')
>>>			lcReqOK = 'Booking requiring specific instructor base would be violated'
>>>        endif
>>>	case b_sched.pref_lvl5=3 and not csrTemp.criteria_2=b_sched.criteria2
>>>		lcReqOK='Booking requiring specific "' + alltrim(prefs_bk.b_crit2) + '" selection would be violated'

>>>
>>>I added today an extra select statement in the lcSQL and the extra case for checking base_id.
>>>
>>>So, when I try to debug this method once I go to the case b_sched.pref_lvl11 = 3 the cursor immediately goes to the endcase at the bottom and exits that method and then the rest of the code in the calling method fires.
>>>
>>>It looks to me that something is wrong on that seek line, but I do not see it. Also, the error method of the form is not firing.
>>>
>>>So, what could it be here?
>>>
>>>Why I can not go to the if not seek line?
>>>
>>>Also, originally the not seek was the same case condition, but I got similar behavior - once the cursor reached that line, it went to the end of the case statement.
>>>
>>>Do you see what I may be missing here?
>>
>>Trace in the debugger or use SET COVERAGE.