Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT SUM() gives me # than SUM... TO
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SELECT SUM() gives me # than SUM... TO
Miscellaneous
Thread ID:
00361638
Message ID:
00361638
Views:
52
Hi,

I have a local view (lv_diario), buffering 5.

And I got different results if I do,

SELECT SUM(field) TO sfield FROM lv_diario INTO CURSOR query1

(query1.sfield)

and,

SUM field TO sfield

When I adding records to the view, everything is Ok, I get these results only modifying existent records and changing the "field" field.

Any suggests? What I'm doing wrong?
Pablo Roca
Clavo Congelados, S.A. (La Coruna - Spain)
Sysop of PortalFox

Join MasFoxPro campaign
http://www.masfoxpro.com
Next
Reply
Map
View

Click here to load this message in the networking platform