>>>>>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.
>
>
You're right. Should I use instead PADL(ModelID, 12,'*') and use something like
*********1********12********13 for the list of models?
instead?
>:-)
>That is why I never put CAs in DE. Put it in Load event of the form (BTW never tested them with NoData = .t.)
I usually don't use DE at all, but I'm trying to follow VPME model here and its tutorial.
If it's not broken, fix it until it is.
My Blog