Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IIF within Insert command
Message
De
21/11/2021 11:33:41
 
 
À
21/11/2021 02:14:26
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01682738
Message ID:
01682756
Vues:
48
Thank you Tore et al who have responded. Truly appreciate all the input.

Im dusting off my old vfp hat so apologize if many changes are beyond my scope of experience hehe..in the past i have used alltrim because sometimes empty just would catch that pesky ghost space but like i said that was my experience many many moons ago...

Again thanks everyone

>>>ALLTRIM is used to often and on meaningless places. In fact, the statement
>>>
>>>..
>>> IIF(EMPTY(Sourcetable.fieldC), "No LIsting Provided", Sourcetable.fieldC);
>>>..
>>>
>>>would do, except Field_C is Varchar. Even then, most likely TRIM() will be enough.
>>
>>Too verbose. I'd prefer
>>
>>... evl(Sourcetable.fieldC, "No LIsting Provided")...
>>
>Thank you for reminding me, I had forgotten about evl().
Thanks in Advance.

J. Turner
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform