TADOQuery how to dynamically add calculated columns TDBGrid this can do

CodePudding user response:

 SELECT SalesOrderID,DATEDIFF (dd, ShipDate, GETDATE ()) AS DaysSinceShipped 
The FROM AdventureWorks. Sales. SalesOrderHeader 
WHERE ShipDate IS NOT NULL 

DaysSinceShipped is computed columns