Do you really need the entire table or just a subset of the records? I suggest you use an updatable view that only works with the records you need. If all you need to work with is new records, then definitely work with a local view. You can then issue a SUM command on the field in the view. Make sure you optimistically table buffer the view also.
>Can someone please tell me if there's a way to use information that has been stored in a table, but not yet committed. In other words, if I have a table that is buffered and I add records with quantities, then I do a SQL - SELECT for a sum of quantities, I only get quantities BEFORE buffering has been turned on. Actually, I want quantities (INCLUDING any changes which haven't been committed)...And, I need them before doing a TABLEUPDATE b/c I still want option to revert table to original state.
>
>I'm sure there should be a way, but can't figure it out.
>
>Thanks,
>
>Victor
Mark McCasland
Midlothian, TX USA