Damn. This whole FILTER, form and variable scoping is a real pain. I'm forced by the form I'm in to use the base table as the source for the form/grid - so no CA
or SQL cursor - but I am having the hardest time getting any of the scenarios to work.
>1) Don't use TRANSFORM, changes to text
>2) Make sure variables as referenced stay in scope
>
>Bob
>
>>I get a datatype mismatch on the SET FILTER command. TransDt is a date. I'm sure this isn't the way to do this, so any help appreciated.
>>
>>THISFORM.FilterCondition = THISFORM.FilterCondition + ' AND BETWEEN(TRANSFORM(TransDt),' + TRANSFORM(THISFORM.TransDtBegin) + ',' + TRANSFORM(THISFORM.TransDtEnd) + ')'
>>m.FilterCondition = THISFORM.FilterCondition
>>SET FILTER TO &FilterCondition
>>