>>>>>>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?
Make them 1 bite bigger that the actual field size, just because if you want some 12 digit Models you can go to this situation:
1 2
------------|------------
123456789012908765432109
-|----------|------------
valid
--|----------|-----------
valid
etc.
But if you make them 13 bites you will get:
1 2
-------------|------------
>
>>:-)
>>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.
Sorry, can't be in help here :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.