Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wrong Type of Variable
Message
De
17/12/2004 13:33:56
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro Beta
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
00969940
Message ID:
00970128
Vues:
20
>>>I see You already got your answer, but, wouldn't this work?
>>>
>>>
>>>local laTotal(1)
>>>
>>>laTotal[1] = 0
>>>select SUM(JN6.nJN6_3) ... Into array laTotal
>>>
>>>* If there were no records "tallied", laTotal would still be 0
>>>
>>>LcMessage = "Amount of it is " + Transform(laTotal[1])
>>>
>>>
>>
>>on VFP9 aggregate functions, a value returns always, eventually NULL.
>>
>>Fabio
>
>Yes, it will return a zero or eventually null as you said, that is why I changed alltrim(str()) to transform, but if you do not want the "Amount of it is NULL" you can use, as you sugested, nvl(laTotal[1], 0), the point is that there is no need to check for _tally, AFAIK

Then you can to improve it:
SET NULLDISPLAY TO 'None'
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform