[v1 V4WS] Does SUM work on ULong fields?

[Steven Ronald]

Ruslan,

>Second. I do not see reason why you afraid ZERO
result.

I am only afraid that sometimes it will NOT be zero if
there are no records to SUM. Will V4WS 1.11 always
give zero (and not some undefined null) if there are
no records to SUM?

Best Regards,
Steven 

>>Is this necessary? Or can I just use

>>cursorRef=valSQLSelect( dbRef_xdb, "SELECT SUM(roop)
>>FROM x WHERE foo<5")

>>sum=valgetfield(cursorRef,1)

>>and if no records are found assume I will always get
>>sum=0?

>>Which is better?


Send instant messages to your online friends http://au.messenger.yahoo.com