>>>>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.
>>>
>>>What do you mean exactly here?
>>
>>About what?
>
>What is wrong with this expression in WHERE clause (except for the fact that it's not optimizable).
I told you yesterday, when you want to get only ModelId==11 and you have:
cast(Models.ModelID as varchar(12)) $ [11]
Then you will get ModelId == 1, as well.
>
>>
>>
>>>
>>>I tested it - re-started VFP in each try and I now have 3 records in a table.
>>
>>And before restarting VFP?
>
>Before re-starting I was getting some weird results. Anyway, I believe the CA is working OK now, but the much more complex problem and bigger challenge is to use it in VPM form and in a grid.
>
>Say, I have this CA added to DE of the form and now the form prompts me for the parameters. Where should I set them then and how - which method. The Help for VPM suggested using them as public variables, which I don't like, obviously.
>
>So, lots of questions to figure out.
:-)
That is why I never put CAs in DE. Put it in Load event of the form (BTW never tested them with NoData = .t.)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.