>I assume that SXELECT SUM()... gives you data from teh actual table on disk while SUM ... TO ... gshows you the pending changes in your buffer? Is this correct? If this is what you see it is because SELECT always reads the file on disk and does not use the buffered data that hasn't yet been saved. I guess that SUM ... TO ... is using the buffered ata in the work station.
Jim,
Ok, then we stand that SELECT SQL, always read from disk and SUM .. TO from the origin even in buffered views. But, Why If I adding records to a buffered (5) view I got correct results for SELECT SQL? It's weird...
Thanks,