Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IIF within Insert command
Message
From
21/11/2021 02:04:19
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
21/11/2021 02:01:47
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01682738
Message ID:
01682749
Views:
35
>>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")...
>
Sure it's such a modern VFP?
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform