>>>How was it working for you, then?
>>>
>>>Also see my previous question - can we make it to use parameters instead?
>>
>>No, because we need to get current values of the fields. And it works because I changed it after I posted it :-)
>>Pust and ASSERT in BeforeUpdate command (after the changes), then _cliptext = cUpdateInsertCmd and try to execute it in command window. See what is wrong.
>
>The CA is working now, thanks. Now to the next challenge - making it to be used in a grid.
>
>BTW, strange thing when I was testing - even if I used release oCA and then repeated my steps, it looked like the previous data were used. The browse showed the data I entered before...

Check the main table DealerOpts and see if the records you are entered/updated are there. Maybe they didn't match the parameters. BTW you SHOULD change:

cast(Models.ModelID as varchar(12)) $ (?getModelIDs)

to use some pattern.