Delphi 2010 Calculated Column In DBGrid

1
votes

I have a Delphi 2010 ADO program that has a DBGrid. Its dataset selects from an Access query. The query has a column defined as, CStr(Amount*UnitCount)+" "+Unit. The query works fine in Access. But the DBgrid refuses to show the values for this column

1
delphiadodelphi-2010dbgrid

1 Answers

1
votes

You'll want to define a calculated field in the TDataset descendant that is connected to your grid, and then implemented the calculation for that field in the OnCalcFields event.