Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wrong Type of Variable
Message
From
17/12/2004 12:57:35
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro Beta
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00969940
Message ID:
00970120
Views:
25
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform