Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IIF character length?
Message
De
03/06/2002 08:32:15
 
 
À
03/06/2002 08:14:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00663995
Message ID:
00664004
Vues:
24
To make it simpler:
SELECT IIF(empty(dtcompl),"''","'" + DTOC(dtcompl) + "'") from mevmast where citat LIKE 'BA83311%'

results in '0

SELECT IIF(empty(dtdisp),"''","'" + DTOC(dtdisp) + "'") from mevmast where citat LIKE 'BA83311%'

results in '10/26/90'

Both fields are of the date type, length 8, and contain a date value. What could cause this?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform