>Hi everybody,
>
>I have a CA with complex SelectCMD expression. I'm building it using VFP Builder and the UpdateNameList expression is wrong.
>
>Fixing it in properties doesn't seem to make an effect.
>
>Here is what has been generated:
>
>OPTSID DealerOpts.OPTSID, OPTIONID NVL(DealerOpts.OPTIONID, MAKEID NVL(DealerOpts.MAKEID, MODELID Models.MODELID, MFGNAME Models.MFGNAME, MODELNAME Models.ModelID as ModelID, MODELNMBR Models.MODELNMBR, MODELYEAR Models.MODELYEAR, RETAIL DealerOptions.RETAIL, COST DealerOptions.COST, COSTLINE DealerOptions.COSTLINE, CTYPE DealerOptions.Cost, STDOPTION DealerOptions.STDOPTION
>
>Is there a way to not auto-generate it, but rather write myself?
>
>Thanks a lot in advance.
>
>UPDATE. I edited it again updating CA class directly in the designer and this time the change stick.

I've noticed something similar yesterday, with an ordinary checkbox - the PEMs I set (caption, caption_yes and caption_no) just wouldn't stick. Luckily, I still had the code to set them in the command window - but the second time around they were lost again. Then I just stuffed the code into its .init() and that did it.