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.