Subject | Re: Calculated Fields - still didn´t got them |
---|---|
Author | roger |
Post date | 2012-09-27T20:51:10Z |
1. To avoid AField = nil, start the function with
if not Assigned(ARow) then
Exit;
2. Don't try using calculated fields in data grids. They are a performance killer, even if really simple. As it happens IBO is faster than other components in this respect, but still not fast enough when scrolling through grids.
If your calculations are necessary, and complicated, put them into a stored procedure, and join the procedure into the query.
Roger Vellacott
if not Assigned(ARow) then
Exit;
2. Don't try using calculated fields in data grids. They are a performance killer, even if really simple. As it happens IBO is faster than other components in this respect, but still not fast enough when scrolling through grids.
If your calculations are necessary, and complicated, put them into a stored procedure, and join the procedure into the query.
Roger Vellacott