Hi.

Anybody know of a way, in one pass, to accumulate a field with SQL code. I would like to do something like:
Select Myfield,Cum(Myfield) as MyCum from myfile into cursor Mycursor
To give following result:

Myfield Mycum
1 1
3 4
2 6
8 14
6 20 etc...

regards,
Gerard