Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trying to come up with a view/CA model
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01410693
Message ID:
01411020
Vues:
50
>>>>>>>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
>-------------|------------
>*123456789012*908765432109
>
>
>
>>
>>>:-)
>>>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 :-)

That's okay, you already get today's patience award ;-)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform