DBgrid update
How can I update my summary dbgrid automatically when I assign a new record to my descritive dbgrid for exp. when I put new expenses in the one table and have the sum of all the expenses in a different table ( my dbgrids are connected with ms access)
14443795638621528496386.jpg
1444379706061-1790036887.jpg
14443795638621528496386.jpg
1444379706061-1790036887.jpg
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If your dataset is connected to real (access) database - new record will be stored in db, so you need to re-query your second query (sum) - after posting - if both forms are active.
qry.Close;
qry.SQL.Text := 'select Period, sum(Value) as Total, ... from tabel2 order by ...'
you can't automatically
an event must be fired and reacted upon
for example update fires afterupdate and in this you refresh the summary
some grids like devexpress quantumgrid allow summarized fields which are automatically updated
those values are not stored in the database, but in the app grid memory
an event must be fired and reacted upon
for example update fires afterupdate and in this you refresh the summary
some grids like devexpress quantumgrid allow summarized fields which are automatically updated
those values are not stored in the database, but in the app grid memory
Premium Content
You need an Expert Office subscription to comment.Start Free Trial