>Larry,
>
>>Once I created the variable as PRIVATE so it could scope down in to the DODEFAULT then it worked as expected. So, now I create the key variable as PRIVATE at the CursorFill method level, run the DODEFAULT and then the results come back and remain. Thanks for pointing out my oversight.
>
>Another option is to add a property to the CursorAdapter to hold the key value, giving it scope for the lifetime of the CA. Then you could do this:

oCA.cMyKey = "whatever"
>oCA.CursorFill()

Then in your CursorFill (or my preference -- in the BeforeCursorFill() method) you patch up the SelectCmd property (cSelectCmd incoming parameter in BeforeCursorFill() ) as you are doing now and use THIS.cMyKey in place of your variable name.

:-)
And if you add ASSIGN method to that property you can automatically refresh CA when you change that property :-) I like this.