Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The textbox in grids simple question
Message
De
10/09/2013 12:39:47
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
À
10/09/2013 12:30:07
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 6 SP3
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01582726
Message ID:
01582731
Vues:
85
This message has been marked as the solution to the initial question of the thread.
>hmmm.. I should be able to set the grids column's textbox controlsource to say:
>
>(IIF(reversals.certrequired = .Null.,"" ,reversals.certrequired))

>so if the certrequired columm is null it displays "", otherwise the value? But the grid is still displaying null.
>
>Am I crazy?

No, but you tried to compare with null, the result of which is always null, which behaves as .f. in an if/iif. Try

?iif(1=null, "is null", "is not")

and see what you get. You should use iif(isnull(something), "", something) if you really want, but why bother with the controlsource? Just

set nulldisplay to ""

and you'll have what you wanted.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform