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.