Hah?

>
>I have changed like below :
>
>

>Do Case
>        Case Thisform.Optiongroup1.Value = 1   &&  All Records
>		Thisform._lcliftdate = ".T."
>	Case Thisform.Optiongroup1.Value = 2   &&  Only Pending Records
>		Thisform._lcliftdate = "liftdate == {}"
>	Case Thisform.Optiongroup1.Value = 3   &&  Only Final Records
>		Thisform._lcliftdate = "liftdate <> {}"
>Endcase
>

>
>
>What alternate we can use for " &lcLiftcond " ?
>
>Warm Regards,
>mk.
>
>
>>Assuming that lcliftdate is a date. If not, adjust acccordingly
>>

>>Do Case
>>        Case Thisform.Optiongroup1.Value = 1   &&  All Records
>>		Thisform._lcliftdate = ".T."
>>	Case Thisform.Optiongroup1.Value = 2   &&  Only Pending Records
>>		Thisform._lcliftdate = "liftdate == {}"
>>	Case Thisform.Optiongroup1.Value = 3   &&  Only Final Records
>>		Thisform._lcliftdate = "not liftdate == {}"
>>>Endcase
>>

>>
>>Another option to try, run first select w/o additional condition. After that use the cursor created as source for the second select with the additional condition.
>>