General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Creating totals in views.
I have a view that has a column I want summed.(optimistic table buffering)
I can use the CALCULATE SUM(.... command on it ok but I am trying to avoid its use because it moves the record pointer causing problems in a grid on my form.
If I do a SELECT SUM(..... on the view I get the wrong result because it does not include uncomitted records. (I do not want to commit the records because I have a cancel button the uses TABLEREVERT)
Is there a way of doing a SELECT from a view that does not insist on using only committed records.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only