Use the where clause from the DB Grid or Scrolling Region data set and
do an update. The underlying table will not know that the form is
looking. Then do a mass posting, then last, refresh the Grid/Region. I
often do an update to a row I am looking at on the form.
To display the total, you use a form variable.
fDBGridTotal = (SUM(Whatever)) FROM <source data>
Then each time you add a row or group of rows
RECALC VARIABLES
Albert
On 8/12/2014 3:03 AM, rehan wyne wrote:
Hi All,
How can I access DB Grid / DB Scrolling Region individual records to
process them in a loop while that DB Grid / DB Scrolling Region is
currently focused in the form?
For Example:
1. If I put "Auto save Off" and I want to put all rows into the base
table ( of DB grid / DB Scrolling Region) after some processing and
verification.
2. I just want to show Grand Total of a column including rows that
were fetched from base table and all newly added rows into DB Grid /
DB Scrolling Region that were not saved yet into base table.
Regards
Rehan Wyne
MIT
