When I need to store totals in a different table (TOTALS.DBF) than the detail (DETAILS.DBF), how can I make sure that both tables are flushed to disk.
I want to save the totals during TABLEUPDATE(DETAILS.DBF), so in the UPDATE TRIGGER I put the code to sum(amount) and replace the TOTALS.DBF field. That way I don't waste time during the TABLEUPDATE() that might get ROLLBACKed. But TOTALS.DBF might be buffered and never TABLEUPDATE()d. The only thing I can think of is to check the Bufffering of TOTALS.DBF and if buffered, USE TOTALS AGAIN unbuffered.
Is there a better way?
I don't want to run a batch process after the fact to do all the totaling, but I'm open to arguments to that affect.
TIA
Bill Morris